edmx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.EnterpriseServices;
using System.Data.EntityModel;
using jayModel;
using System.Data.Linq.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
/*name of entity class is jay*/
    jayEntities j = new jayEntities();
    Table1 t = new Table1();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int i = Convert.ToInt32(TextBox1.Text);

       
        /* If where condition for one field  Require using query */
     
        var a = j.Table1.Where(m => m.id == i).ToList().Select(m => m.name);
       
     
        GridView1.DataSource = a;
        GridView1.DataBind();

        /* if where condition  require */
 /*here name start with h and contain c  */
        var d1 = j.Table1.Where(f => f.name.StartsWith("h")&& f.name.Contains("c")).Select(f=>f.name);
     
        /*Display two field
       
        //var d1 = j.Table1.Select(f => new { f.id,f.name}).OrderBy(f=>f.name).Where(f=>f.id==i);
     //  var d4 = j.Table1.Select(f => new { f.name });*/

        GridView2.DataSource = d1;
        GridView2.DataBind();
        /*All Table Data */
        var d2 = j.Table1.ToList();
        GridView3.DataSource = d2;
        GridView3.DataBind();
        /*If where condition for two field  Require */


        //List<jayModel.Table1> list = new List<jayModel.Table1>();
        var list = j.Table1.Where(m => m.id == i).ToList();
        //var list1 = j.count_tbl.Where(m => m.id == i).ToList();
        var objJoin = list.Join(list, b => b.id, c => c.id, (b, c) => new { name = b.name, address = b.Address });
        //left outer join using edmx
        var q = from t1 in j.Table1
                join t2 in j.count_tbl on t1.id equals t2.id into t1t2
                from t2 in t1t2.DefaultIfEmpty()
                select new { t1.id, t1.name };
        //right outer join using edmx
        var q1 = from t2 in j.count_tbl join t1 in j.Table1 on t2.id equals t1.id into t1t2 from t1 in t1t2.DefaultIfEmpty() select new { t2.month, t2.number, t1.name };

        GridView4.DataSource = q1;
        GridView4.DataBind();
    }
}