I am just trying to return true, if there are records in database for given example. If there are no records, it should return false. Can you help me with an example how can i achieve it

public static bool ismembernoexist() { try { var adaptermember = new DataAccessAdapter(); var member = new EntityCollection(new MemberEntityFactory()); var bucketmember = new RelationPredicateBucket();

            bucketmember.PredicateExpression.Add(MemberFields.Flag == 0); // Filter by flag
            bucketmember.PredicateExpression.Add(MemberFields.Memberno == "B-100"); // Filter by Memberaccno
            adaptermember.FetchEntityCollection(member, bucketmember, 0);




            return true;
        }
        catch (Exception ex)
        {
            return false;

        }

You may check on the fetched entityCollection count, property.

Walaa wrote:

You may check on the fetched entityCollection count, property.

Like this?

var adaptermember = new DataAccessAdapter(); var member = new EntityCollection(new MemberEntityFactory()); var bucketmember = new RelationPredicateBucket();

        bucketmember.PredicateExpression.Add(MemberFields.Flag == 0); // Filter by flag input
        bucketmember.PredicateExpression.Add(MemberFields.Memberno == "B-100"); // Filter by Memberaccno input
        //adaptermember.FetchEntityCollection(member, bucketmember, 0);
        var count = adaptermember.GetDbCount(member, bucketmember);
        if (count == 0)
        {
            return false;
        }
        return true;

No like this:

            var adaptermember = new DataAccessAdapter();
            var member = new EntityCollection(new MemberEntityFactory());
            var bucketmember = new RelationPredicateBucket();

            bucketmember.PredicateExpression.Add(MemberFields.Flag == 0); // Filter by flag input
            bucketmember.PredicateExpression.Add(MemberFields.Memberno == "B-100"); // Filter by Memberaccno input
            adaptermember.FetchEntityCollection(member, bucketmember, 0);
            if (member.Count <= 0)
            {
                return false;
            }
            return true; 

Walaa wrote:

No like this:

            var adaptermember = new DataAccessAdapter();
            var member = new EntityCollection(new MemberEntityFactory());
            var bucketmember = new RelationPredicateBucket();

            bucketmember.PredicateExpression.Add(MemberFields.Flag == 0); // Filter by flag input
            bucketmember.PredicateExpression.Add(MemberFields.Memberno == "B-100"); // Filter by Memberaccno input
            adaptermember.FetchEntityCollection(member, bucketmember, 0);
            if (member.Count <= 0)
            {
                return false;
            }
            return true; 

Great ! thanks for quick help

Sorry just forgot one more thing...

I want to pass the output of this query to dataset. how can I achieve the same ?

var adaptermember = new DataAccessAdapter(); var member = new EntityCollection(new MemberEntityFactory()); var bucketmember = new RelationPredicateBucket();

        bucketmember.PredicateExpression.Add(MemberFields.Flag == 0); // Filter by Flag 
        bucketmember.PredicateExpression.Add(MemberFields.Memberno == "B-100"); // Filter by Memberaccno 
        adaptermember.FetchEntityCollection(member, bucketmember, 0);

Please check the manual for how to Project the data to a DataTable/DataSet