Yeah, the Linq expressions really need some work and are incomplete in the current version. It would work to chain them together, like this:

var contactList = _repo.Find<Contact>(x => x.AccountId == slxAccountId).Where(x => x.Isprimary == "T").ToList();

In the code above it is important to remember a few things. The first expression is used to retreive the records from the database, then the IList is refined down to a smaller set using the Linq Where. So, in the case of this example it isn't a huge deal. You'll get back all contacts for the current account and then the list is refined to contain only the one(s) where Isprimary == "T". In other cases this wouldn't work so well since you might bring back too much data to make it worth it. In these cases you'd want to use the _repo.Select even though you loose intellisense just for performance sake. I do have a version coming where you can select properties instead of including them as strings, but ideally I need to get the Linq expression tree parsing complete so you can write more complex expressions for Find. That will come, but I don't exactly have it on my radar for newar future yet.

The simple way to get auto-complete feature.

Instead of

IList<Contact> contactList = Repository.Select<Contact>()
.Where("AccountId", Operator.Equals, slxAccountId)
.Execute();

Use

IList<Contact> contactList = Repository.Select<Contact>()
.Where(GetElementName<Contact>(x => x.AccountId), Operator.Equals, slxAccountId)
.Execute();

Also, you need add this code to your project:

public static string GetElementName<TItem>(this TItem obj, Expression<Func<TItem, object>> expression)
    where TItem : IEntity
{
    return GetElementName(expression);
}

public static string GetElementName<TItem>(Expression<Func<TItem, object>> expression)
    where TItem : IEntity
{
    var body = expression.Body as MemberExpression;
    if (body == null)
    {
        throw new ArgumentException("Expression is not a member access", "expression");
    }

    var entityElement = (EntityElementAttribute) body.Member
     .GetCustomAttributes(typeof (EntityElementAttribute), false)
     .Single();

    return entityElement.Name;
}

This works to me fine.

Andrei,

That is awesome. I've added this into a new helper class in Sublogix. You'll find this useful method as EntityHelper.GetElementName. Once you update to Sublogix version 1.3.1.0 (which has now been released to NuGet), you can now use this built-in without the need to add the method to your own code (you'll need to add a using directive for Sublogix.Helpers).

IList<Contact> contactList = Repository.Select<Contact>()
.Where(EntityHelper.GetElementName<Contact>(x => x.AccountId), Operator.Equals, slxAccountId)
.Execute();

Thanks again!

I've update sublogix upto 1.3.1.0 in my app - works well, thank you for including this feature into your project!