数据库
人工智能
工具资源
教程文章
学习资料
文档手册
.NET
编程开发542
编程开发518
编程开发403
编程开发342
编程开发180
编程开发173
编程开发170
编程开发165
编程开发154
编程开发143
XAML:Button1 LINQ TO ENTITYusing (var context = new AdventureWorks2008Entities()){//var people = context.People.Where(c => c.LastName == "King").OrderBy(d => d.FirstName).Select(r => new { r.FirstName,r.LastName});//var people = context.People.Where(c => c.LastName == "King").OrderBy(c =>c.FirstName).Select(c => new { c.FirstName, c.LastName });var people = from per in context.People//join emp in context.Employees on per.BusinessEntityID equals emp.BusinessEntityIDwhere per.LastName == "King"orderby per.FirstNameselect new { per.FirstName, per.LastName};foreach (var person in people){listBox1.Items.Add(string.Format("{0} t t {1} ", person.FirstName, person.LastName));}}Button2 LINQ TO ENTITYSQLusing (var context = new AdventureWorks2008Entities()){var str = "SELECT VALUE p FROM AdventureWorks2008Entities.People AS p WHERE p.LastName= @LastName Order by p.FirstName";//var people = context.CreateQuery(str);var people = new System.Data.Objects.ObjectQuery(str, context);people.Parameters.Add(new System.Data.Objects.ObjectParameter("LastName", "King"));foreach (var person in people){listBox2.Items.Add(string.Format("{0} t t{1}", person.FirstName, person.LastName));}}Button3 LINQ TO ENTITYCLIENTvar firstName = "";var lastName = "";using (EntityConnection conn = new EntityConnection("name=AdventureWorks2008Entities")){string str = "SELECT p.FirstName, p.LastName FROM AdventureWorks2008Entities.People AS p WHERE p.LastName='King' Order by p.FirstName";conn.Open();EntityCommand cmd = conn.CreateCommand();cmd.CommandText =str;using (EntityDataReader rdr = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess)){while (rdr.Read()){firstName = rdr.GetString(0);lastName = rdr.GetString(1);listBox3.Items.Add(string.Format("{0}t t{1}", firstName, lastName));}}conn.Close();}}