Cannot Resolve Symbol Select in ActiveRecord Fluent Query

subsonic3

What could possibly be wrong here?

    public Contact GetContact(int key)
    {
        var contact = new ContactManagerDB.Select
            .From<Contact>()
            .Where(ContactsTable.IdColumn).IsEqualTo(key)
            .ExecuteSingle<Contact>();

        return contact;
    }

ReSharper 4.5: Cannot resolve symbol Select.

Oh, I should mention that the classes are working fine using Linq.

Best Solution

Just comparing your query syntax to the one on the subsonic website, You're selecting a single object from the database of type Contact, but you're naming your result variable as type var named contact. Try changing var contact to Contact c and then return c; at the end. It might just be that the query is looking for a Select function symbol that returns type var when selecting type Contact.

Related Question