
Untitled
By: a guest on
May 9th, 2012 | syntax:
None | size: 0.46 KB | hits: 17 | expires: Never
Working with stored procedure in LINQ?
MyLinqsDataContext DataContext=new MyLinqsDataContext ();
int eno=Convert.ToInt32 (txtempno.Text );
int dep=Convert .ToInt32 (txtDep.Text );
var sqr = from qr in DataContext.USP_Insert_Emp(eno, txtName.Text, dep)
select qr;
create procedure USP_Insert_Emp(@empid int,@ename varchar(60),@deptid int)
as
begin
insert into Emp (empid ,ename,deptid ) values (@empid ,@ename ,@deptid)
end