Linq小例子

1使用前先先建linq类，然后创建连接托表过来

2创建连接字符串DBTestConnectionString，添加表后自动已经添加，这里设置好一个字符串变量接收
static string Constr = ConfigurationManager.ConnectionStrings["DBTestConnectionString"].ToString();

3创建LinqDataDataContext，其中LinqData是你创建的linq类的名字
    LinqDataDataContext linq = new LinqDataDataContext(Constr);

然后使用linq语句查询
var value = from v in linq.用户表
                    select v;
        GridView1.DataSource = value;
        GridView1.DataBind();

4或者使用linq.ExecuteCommand(sql)>0 执行sql语句命令
或 IEnumerable<类> restult = linq.ExecuteQuery<类>(sql)；进行查询
 迭代器只能查询一列

5连接查询

 var value = from v in linq.新闻表
                    join t in linq.新闻类别表 on v.新闻类别 equals t.id into x
                    select new
                    {
                        v.ID,
                        v.新闻类别表.typename,
                        v.新闻标题,
                        v.PubTime,
                        v.PubPerson,
                        v.新闻内容,
                        v.IsShown
                    };
        GridView1.DataSource = value;
        GridView1.DataBind();

 

6自身增删改

增加记录：
用户表 user=new 用户表 ();
        user.UserName = txtname.Text.Trim();
        user.MyPwd = txtpwd.Text.Trim();
        linq.用户表.InsertOnSubmit(user);
        linq.SubmitChanges();
        bind();  

删除记录
var value = from v in linq.用户表
                    where v.ID == Convert.ToInt32(txtid.Text.Trim())
                    select v;
        linq.用户表.DeleteAllOnSubmit(value);
        linq.SubmitChanges();
        bind();

更新记录
var value = from v in linq.用户表
                    where v.ID == Convert.ToInt32(txtid.Text.Trim())
                    select v;
        foreach (用户表 user in value)
        {
            user.UserName = txtname.Text;
            user.MyPwd = txtpwd.Text;
        }
        linq.SubmitChanges();       
        bind();