Difference Between SELECT Query of LINQ and SQL
Published: 11/02/2009 by Vinoth Kannan S
Example 1 :
SQL => SELECT * FROM users.
LINQ =>
J = New UsersDataClassDataContext();
k = From l in J.users
******************************************************************
Example 2 :
SQL => SELECT * FROM users WHERE username = 'xxx'
LINQ =>
k = From l in J.users WHERE l.username = 'xxx'
***********************************************************************************************
Example 3 :
SQL => SELECT username, password FROM users WHERE id = 10
LINQ =>
k = From l in J.users Where l.id = 10 Select l.username, l.password
