LinqtoSqlDataContext Linq = new LinqtoSqlDataContext(ConfigurationManager.ConnectionStrings["sz_imt20131024pmConnectionString"].ConnectionString);
var query = from usersTable in Linq.UsersTable where usersTable.Uid > 1&&usersTable.Username.StartsWith("张") orderby usersTable.Uid descending select new { Uid = usersTable.Uid, Username = usersTable.Username }; 或者 var query= Linq.UsersTable.Where(a => a.Uid > 1 && a.Username.StartsWith("张"));
UsersTable user = new UsersTable { Username = "小张", Sex = "女", Password = "123" }; Linq.UsersTable.InsertOnSubmit(user); Linq.SubmitChanges();
UsersTable UT = Linq.UsersTable.Single(a => a.Uid == 1); UT.Username = "小明"; Linq.SubmitChanges();
UsersTable UT = Linq.UsersTable.Single(a => a.Uid == 3); Linq.UsersTable.DeleteOnSubmit(UT); Linq.SubmitChanges();
//输出参数 string name=""; Linq:DataContext对象;PROC_SELECTBYUID:存储过程名称 var query = Linq.PROC_SELECTBYUID(ref name);
//字符串数组 string[] starts = new string[2]; ParameterExpression c = Expression.Parameter(typeof(K_SysModuleNode), "c"); Expression condition = Expression.Constant(false); foreach (string item in starts) { Expression con = Expression.Call( Expression.Property(c, typeof(K_SysModuleNode).GetProperty("NodeName")), typeof(string).GetMethod("StartsWith", new Type[] { typeof(string) }), Expression.Constant(item) ); condition = Expression.Or(con,condition); } Expression<Func<K_SysModuleNode, bool>> end = Expression.Lambda<Func<K_SysModuleNode, bool>>(condition, new ParameterExpression[] { c }); var query = Linq.K_SysModuleNode.Where(end);