What is Insert Statement In (SQL and LINQ) and Synthax

Insert command is called as DML functions.
this is very useful for inserting new records in data base.

Syntax  SQL :

Insert into tablename values(col1values ,cal2values...);

Syntax LINQ :

LinqToSQL objLinqToSQL = new LinqToSQL();

Employee   objEmployee =new Employee ();

objEmployee .EMPid=001;
objEmployee .First_name=Prasad;
objEmployee .Middle_Name=K;
objEmployee .Lost_Name=M;

objLinqToSQ.InsertALL( objEmployee);
objLinqToSQ.SubmitAll();

Example SQL :

Insert into Employee (001,'Prasad','K',M') Press F5 in MSSQL

 

Please check the result :

SQL :-

select * from  Employee  Press F5 in MSSQL

LINQ : 

var data=from d in  Employee select instance;

Result : -
----------------------------------------------------------------------------
 | Employe_id | First_Name | Middle_Name | Lost_Name|

---------------------------------------------------------------

 | 001              | Prasad          | K                      |M                 |
---------------------------------------------------------------