LinqPad recognises the database but not the table
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
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
Comments
-
Check the casing of the column name as C# is case sensitive.. also the equality operator for c# is ==
-
Thanks Nescafe, you picked up both issues.Resolved.
Ta
