static void func1() {
//LINQ访问数组(LINQ TO Object)
int[] array = {1,5,3,7,2,9,4,6 };
//利用LINQ表达式对数组进行查询(检索数组中大于5的元素)
var v = from arr in array where arr > 5 orderby arr descending select arr;
foreach(int num in v){
Console.WriteLine(num);
}
}
static void func3() {
//使用LINQ执行数据库查询
//将LINQ与数据库的关系理解为ORM(对象关系映射)
//1.创建一个LINQ操作SQLServer数据库对象
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
//2.创建LINQ查询表达式
var emps = from e in lqDB.Emp select e;
foreach(Emp emp in emps){
Console.WriteLine(emp.empno+"-"+emp.ename+"-"+emp.deptno);
}
}
static void func4() {
//使用LINQ向数据库中插入数据
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
Emp emp = new Emp();
emp.empno = 1;
emp.ename = "张三";
emp.sal = 5000;
emp.deptno = 20;
//LINQ向Emp表插入数据
lqDB.Emp.InsertOnSubmit(emp);
lqDB.SubmitChanges();
Console.WriteLine("数据插入成功!");
}
static void func5() {
//使用LINQ向数据库中更新数据
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
var obj = from e in lqDB.Emp where e.empno == 1 select e;
foreach(Emp emp in obj){
emp.ename = "张老三";
emp.sal = 10000;
}
//将数据的变化提交到数据库中
lqDB.SubmitChanges();
Console.WriteLine("数据修改成功!");
}
static void func6() {
//使用LINQ向数据库中删除数据
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
var obj = from e in lqDB.Emp where e.empno == 1 select e;
lqDB.Emp.DeleteAllOnSubmit(obj);
lqDB.SubmitChanges();
Console.WriteLine("数据删除成功!");
//LINQ访问数组(LINQ TO Object)
int[] array = {1,5,3,7,2,9,4,6 };
//利用LINQ表达式对数组进行查询(检索数组中大于5的元素)
var v = from arr in array where arr > 5 orderby arr descending select arr;
foreach(int num in v){
Console.WriteLine(num);
}
}
static void func3() {
//使用LINQ执行数据库查询
//将LINQ与数据库的关系理解为ORM(对象关系映射)
//1.创建一个LINQ操作SQLServer数据库对象
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
//2.创建LINQ查询表达式
var emps = from e in lqDB.Emp select e;
foreach(Emp emp in emps){
Console.WriteLine(emp.empno+"-"+emp.ename+"-"+emp.deptno);
}
}
static void func4() {
//使用LINQ向数据库中插入数据
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
Emp emp = new Emp();
emp.empno = 1;
emp.ename = "张三";
emp.sal = 5000;
emp.deptno = 20;
//LINQ向Emp表插入数据
lqDB.Emp.InsertOnSubmit(emp);
lqDB.SubmitChanges();
Console.WriteLine("数据插入成功!");
}
static void func5() {
//使用LINQ向数据库中更新数据
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
var obj = from e in lqDB.Emp where e.empno == 1 select e;
foreach(Emp emp in obj){
emp.ename = "张老三";
emp.sal = 10000;
}
//将数据的变化提交到数据库中
lqDB.SubmitChanges();
Console.WriteLine("数据修改成功!");
}
static void func6() {
//使用LINQ向数据库中删除数据
lqDBDataContext lqDB = new lqDBDataContext(ConfigurationManager.ConnectionStrings["companyConnectionString"].ToString());
var obj = from e in lqDB.Emp where e.empno == 1 select e;
lqDB.Emp.DeleteAllOnSubmit(obj);
lqDB.SubmitChanges();
Console.WriteLine("数据删除成功!");