static void Main(string[] args)
{
using (var dbContext = new EF13Entities())
{
dbContext.Database.Log = info => Console.WriteLine(info); //WriteLog;
//添加
//SampleTable sampleTable = new SampleTable { Age = 18, Gender = true, Name = "张三" };
//dbContext.SampleTable.Add(sampleTable);
//dbContext.SaveChanges();
//添加多个
//List<SampleTable> sampleTables = new List<SampleTable> {
// new SampleTable{ Age=17,Gender=true,Name="A1" },
// new SampleTable{ Age=18,Gender=true,Name="A2" },
// new SampleTable{ Age=19,Gender=false,Name="A3" },
// new SampleTable{ Age=20,Gender=true,Name="A4" },
// new SampleTable{ Age=21,Gender=false,Name="A5" }
//};
//dbContext.SampleTable.AddRange(sampleTables);
//查询
//var temp = dbContext.SampleTable.Find(3);
//根据年龄范围查询
//var temp = dbContext.SampleTable.Where(x => x.Age >= 17 && x.Age <= 20);
//foreach (var item in temp)
//{
// Console.WriteLine(item.Id + "," + item.Name + "," + item.Age + "," + item.Gender);
//}
//删除一个
//dbContext.SampleTable.Remove(temp);
//删除多个
//var temp = dbContext.SampleTable.Where(x => x.Age == 18);
//dbContext.SampleTable.RemoveRange(temp);
//更新
var temp = dbContext.SampleTable.Where(x => x.Age >= 17 && x.Age <= 20);
//var list = temp.ToList();
//for (int i = 0; i < list.Count; i++)
//{
// list[i].Gender = true;
//}
foreach (var item in temp)
{
item.Gender = true;
}
//SampleTable sampleTable = new SampleTable { Age = 18, Gender = true, Name = "张三" };
//eF13Entities.SampleTable.Add(sampleTable);
//eF13Entities.SampleTable.Remove(temp);
//temp.Name = "李四";
dbContext.SaveChanges();
}
Console.WriteLine("执行完毕");
Console.ReadLine();
}
static void Main(string[] args)
{
using (var dbContext = new EF13Entities())
{
dbContext.Database.Log = info => Console.WriteLine(info); //WriteLog;
var query =
from d in dbContext.SampleTable
where d.Id == 2
select d;
var result = query.FirstOrDefault();
result.Name = "李四3";
dbContext.Entry <SampleTable>(result).State = System.Data.Entity.EntityState.Deleted;
dbContext.SaveChanges();
//string sql = "SELECT * FROM SampleTable WHERE ID=1";
//var result = dbContext.Database.SqlQuery<SampleTable>(sql);
//foreach (var item in result)
//{
// Console.WriteLine(item.Name);
// item.Name = "张三2";
// dbContext.Entry<SampleTable>(item).State = System.Data.Entity.EntityState.Modified;
//}
//dbContext.SaveChanges();
//string sql = "SELECT * FROM TEST WHERE ID=@p0";
//SqlParameter[] sqlParameters = {
// new SqlParameter("@p0",2)
//};
//var result = dbContext.Database.SqlQuery<Test>(sql, new SqlParameter("@p0", 2));
////var result = dbContext.Database.SqlQuery<Test>(sql,sqlParameters);
//foreach (var item in result)
//{
// Console.WriteLine(item.Account);
//}
//string sql = "SELECT * FROM TEST";
//var result = dbContext.Database.SqlQuery<Test>(sql);
//foreach (var item in result)
//{
// Console.WriteLine(item.Account);
//}
//string sql = "SELECT COUNT(*) FROM TEST";
//var result = dbContext.Database.SqlQuery<int>(sql).FirstOrDefault();
//Console.WriteLine("查询结果：\t" + result);
//string sql = "SELECT COUNT(*) FROM TEST";
////var result = dbContext.Database.SqlQuery<int>(sql).ToArray();
//var result = dbContext.Database.SqlQuery<int>(sql).ToList();
//Console.WriteLine("查询结果：\t" + result[0]);
//dbContext.Database.SqlQuery(,);
//string sql = "SELECT COUNT(*) FROM TEST";
//var result = dbContext.Database.SqlQuery<int>(sql);
//foreach (var item in result)
//{
// Console.WriteLine("查询结果：\t" + item);
//}
//string sql = "DROP TABLE Test";
//var result = dbContext.Database.ExecuteSqlCommand(sql);
//Console.WriteLine(result);
//string sql = "delete from Test";
//var result = dbContext.Database.ExecuteSqlCommand(sql);
//Console.WriteLine(result);
//string sql = "UPDATE Test SET Password=@Password WHERE Account=@Account";
//SqlParameter[] sqlParameters = {
// new SqlParameter("@Account","Account"),
// new SqlParameter("@Password","11111111")
//};
//var result = dbContext.Database.ExecuteSqlCommand(sql, sqlParameters);
//Console.WriteLine(result);
//string sql = "INSERT INTO Test(Account,Password) VALUES(@Account,@Password)";
////SqlParameter[] sqlParameters = new SqlParameter[] {
//// new SqlParameter("@Account","MyAccount"),
//// new SqlParameter("@Password","MyPassword")
////};
//SqlParameter[] sqlParameters = {
// new SqlParameter("@Account","MyAccount1"),
// new SqlParameter("@Password","MyPassword1")
//};
//var result = dbContext.Database.ExecuteSqlCommand(sql, sqlParameters);
//Console.WriteLine(result);
//string sql = "INSERT INTO Test(Account,Password) VALUES('Account3','Password3')";
//var result = dbContext.Database.ExecuteSqlCommand(sql);
//Console.WriteLine(result);
//string sql = @"
//CREATE TABLE [dbo].[Test] (
// [Id] INT IDENTITY (1, 1) NOT NULL,
// [Account] VARCHAR (10) NULL,
// [Password] VARCHAR (20) NULL
// PRIMARY KEY CLUSTERED ([Id] ASC)
//);";
//var result = dbContext.Database.ExecuteSqlCommand(sql);
//Console.WriteLine(result);
//添加
//SampleTable sampleTable = new SampleTable { Age = 18, Gender = true, Name = "张三" };
//dbContext.SampleTable.Add(sampleTable);
//dbContext.SaveChanges();
//添加多个
//List<SampleTable> sampleTables = new List<SampleTable> {
// new SampleTable{ Age=17,Gender=true,Name="A1" },
// new SampleTable{ Age=18,Gender=true,Name="A2" },
// new SampleTable{ Age=19,Gender=false,Name="A3" },
// new SampleTable{ Age=20,Gender=true,Name="A4" },
// new SampleTable{ Age=21,Gender=false,Name="A5" }
//};
//dbContext.SampleTable.AddRange(sampleTables);
//查询
//var temp = dbContext.SampleTable.Find(3);
//根据年龄范围查询
//var temp = dbContext.SampleTable.Where(x => x.Age >= 17 && x.Age <= 20);
//var temp = from d in dbContext.SampleTable
// where d.Age >= 17 && d.Age <= 20
// select d;
//foreach (var item in temp)
//{
// Console.WriteLine(item.Id + "," + item.Name + "," + item.Age + "," + item.Gender);
//}
//删除一个
//dbContext.SampleTable.Remove(temp);
//删除多个
//var temp = dbContext.SampleTable.Where(x => x.Age == 18);
//dbContext.SampleTable.RemoveRange(temp);
//更新
//var temp = dbContext.SampleTable.Where(x => x.Age >= 17 && x.Age <= 20);
//var list = temp.ToList();
//for (int i = 0; i < list.Count; i++)
//{
// list[i].Gender = true;
//}
//foreach (var item in temp)
//{
// item.Gender = true;
//}
//SampleTable sampleTable = new SampleTable { Age = 18, Gender = true, Name = "张三" };
//eF13Entities.SampleTable.Add(sampleTable);
//eF13Entities.SampleTable.Remove(temp);
//temp.Name = "李四";
//dbContext.SaveChanges();
}
Console.WriteLine("执行完毕");
Console.ReadLine();
}