说明:首先在项目中添加 新建项 LINQ to SQL类
自定义类代码如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace SQL_LINQ
{
class linq_To_SqlServer
{
//查询
public void Select()
{
DataTestDataContext dc = new DataTestDataContext(); //创建对象
var user = from u in dc.User orderby u.U_Id descending select u; //查询语句
Console.WriteLine("按照ID倒序排列:");
foreach (var item in user)
{
Console.WriteLine(item.U_Name);
}
}
//插入
public void Insert()
{
User user = new User { U_Name = "毛八", U_Pwd = "3" }; //插入数据
DataTestDataContext dc = new DataTes