LinqPad recognises the database but not the table

cyoker

hiya folks,

I've connected to the db and can see the tables in the left hand side panel.

Below is the query: (C# expression)

from c in Contacts
where c.contactId = 12
select new
{
c.name
}

Error:
Cannot execute text selection: 'LINQPad.User.Contacts' does not contain a definition for 'contact_number' and no extension method 'contactId' accepting a first argument of type 'LINQPad.User.Contacts' could be found (press F4 to add a using directive or assembly reference)

I'm not sure why I'd have to add refrences, as I believe that linqPad should be aware of the table...Any ideas?

Thanks,

Chris

nescafe

Check the casing of the column name as C# is case sensitive.. also the equality operator for c# is ==

cyoker

Thanks Nescafe, you picked up both issues.Resolved.

Ta