linq using Store Procedure

Add class……

using System;

using System.Data.Linq;

using System.Data.Linq.Mapping;

[Table(Name="student")]

public class E_modal

{

    [Column(Name = "roll_no", IsPrimaryKey = true)]

    public int rno { get; set; }

    [Column(Name = "stud_name")]

    public string sn { get; set; }

    [Column(Name = "stud_course")]

    public string sc { get; set; }

    [Column(Name = "stud_fees")]

    public int sf { get ;set; }

      

}

.aspx page

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.Linq;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        DataContext d = new DataContext("initial catalog=batch4;data source=dev-pc;integrated security=yes");

       Table< E_modal > e1= d.GetTable< E_modal >();

       GridView1.DataSource = e1;

       GridView1.DataBind();

    }

}

 

Using stored procedure

Add class EM<ENTITY MODAL>

using System;

using System.Data.Linq;

using System.Data.Linq.Mapping;

[Table(Name = "student")]

public class EM

{

    [Column(Name = "roll_no", IsPrimaryKey = true)]

    public int rno { get; set; }

    [Column(Name = "stud_name")]

    public string sn { get; set; }

    [Column(Name = "stud_course")]

    public string sc { get; set; }

    [Column(Name = "stud_fees")]

    public int sf { get; set; }

}

ADD CLASS DAL

using System;

using System.Data.Linq;

using System.Data.Linq.Mapping;

using System.Reflection;

public class DAL : DataContext

{

    public DAL(string x)

        : base(x)

    {

    }

    [Function(Name = "s_show")]

    public ISingleResult<EM> show()

    {

        IExecuteResult res = this.ExecuteMethodCall(this, (MethodInfo)MethodInfo.GetCurrentMethod());

        ISingleResult<EM> s = (ISingleResult<EM>)res.ReturnValue;

        return s;

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        DAL d = new DAL("initial catalog=batch4;data source=dev-pc;integrated security=yes");

        GridView1.DataSource = d.show();

        GridView1.DataBind();

    }

}

[3/29/2010 7:52:12 PM] sandeep karan: http://msdn.microsoft.com/en-us/library/ms998549.aspx

[3/29/2010 9:15:56 PM] sandeep karan: using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Reflection;

using System.Data.Linq;

using System.Data.Linq.Mapping;     

public class Class2:DataContext

{

 public Class2(string c):base(c)

 {

 

 }

    [Function(Name="sel_prod")]

    public ISingleResult<Class1> show()

    {

      IExecuteResult res=this.ExecuteMethodCall(this,(MethodInfo)MethodInfo.GetCurrentMethod());

      ISingleResult<Class1> s = (ISingleResult<Class1>)res.ReturnValue;

      return s;

    }

}

[3/29/2010 9:20:01 PM] sandeep karan: using System;

using System.Collections.Generic;

using System.Linq;

using System.Reflection;

using System.Data.Linq;

using System.Data.Linq.Mapping;

public class DAL:DataContext

{

    public DAL(string connection)

        : base(connection)

    {

    }

    [Function(Name="usp_SelectCustomer")]

    public ISingleResult<st>  getdata()

    {

       IExecuteResult obj=this.ExecuteMethodCall(this, (MethodInfo)MethodInfo.GetCurrentMethod());

       ISingleResult<st> ret=(ISingleResult<st>)obj.ReturnValue;

       return ret;

    }

    [Function(Name = "customerbyid")]

    public ISingleResult<st> getdataid([Parameter(Name = "cid", DbType = "Int")] System.Nullable<int> id)

    {

        IExecuteResult obj = this.ExecuteMethodCall(this, (MethodInfo)MethodInfo.GetCurrentMethod(),id);

        ISingleResult<st> ret = (ISingleResult<st>)obj.ReturnValue;

        return ret;

    }

   

    [Function(Name = "insertc")]

    public int InsertCustomer([Parameter(Name = "Cid", DbType = "Int")]

 int  CustId, [Parameter(Name = "Cname",DbType = "nvarchar(20)")]string custname)

    {

        IExecuteResult result = this.ExecuteMethodCall(this,

        ((MethodInfo)(MethodInfo.GetCurrentMethod())), CustId, custname);

        return (int)result.ReturnValue;

    }

}