Can anyone tell me how to go about coding a search function.

Actually i want to return one field value whereas as using 2 filters... I tried something like this...but it is wrong...i guess

static public CalendarEntity GetResult(int month, int Year) { DataAccessAdapter adapter = new DataAccessAdapter(dbConnectionString()); CalendarEntity targetID = new CalendarEntity(); IPredicateExpression filter = new PredicateExpression(); filter.Add(CalendarFields.MonthCode == month); filter.Add(CalendarFields.Year == Year); adapter.FetchEntityCollection(targetID,0,filter); ????? adapter.Dispose(); return targetID; }

Can anyone help me in this...i dnt want to return entity collection.....

Thanks in advance

Hi,

you can use the FetchEntityUsingUniqueConstraint method, that will fetch only one entity using your filter.

i want to return one field value

Use a dynamic List of one field.

Or use adapter.GetScalar