By default, when you drag database objects that have names ending in 's' or 'ies' from Server Explorer / Database Explorer onto the Object Relational Designer (O/R Designer) , the names of the generated entity classes are changed from plural to singular.
This is done to more accurately represent the fact that the instantiated entity class maps to a single record of data. For example, adding a Members table to the O/R Designer results in an entity class named Member because the class will hold data for only a single Member.
Pluralization is on by default only in the English-language version of Visual Studio.
Source : MSDN
First of all, we need to add a .dbml file as explained in previous post.
I was trying the following LINQ to SQL code.
Cannot implicitly convert type 'System.Linq.IQueryable<AnonymousType#1>'
I have explicitly created a class MemberBasicInfo containing FirstName, Gender and Email as properties and modified the LINQ to SQL query as shown below & it was working fine.
Hope! this will be helpful to LINQ to SQL learners.