Difference Between LINQ and SQL Select with Where Condition Query  Syntax.

The select statement is used in SQL to specify what data you would like returned when querying the MSSQL MYSQL LINQ database. An asterisks [*] will return all data, or you can choose specific data. 

The WHERE clause is used to extract only those records that fulfill a specified criterion.

The WHERE clause is used to filter the data in a table.

The WHERE clause is used to filter the data in a View.

SQL : select(clause) * from (clause) from <table Name> where(clause) column =value

           select * from customer where id =100

LINQ : from <instance> in <table name or table object name> where (clause) column=value

             select <instance>

           from cust in customer where cust.id. Equuleus (100) select cust;