public static async Task <int> 异步聚合函数() { using (var db = new DonatorContext()) { return(await db.Donators.CountAsync()); } }
public static async Task <IEnumerable <Donator> > 异步查询对象列表() { using (var db = new DonatorContext()) { return(await db.Donators.ToListAsync()); } }
public static async Task 异步创建对象(Donator donator) { using (var db = new DonatorContext()) { db.Donators.Add(donator); await db.SaveChangesAsync(); } }
public static async Task <Donator> 异步定位一条记录(int donatorId) { using (var db = new DonatorContext()) { return(await db.Donators.FindAsync(donatorId)); //return await db.Donators.FirstAsync(donatorId); } }
public static async Task 异步遍历查询结果() { using (var db = new DonatorContext()) { await db.Donators.ForEachAsync(d => { d.DonateDate = DateTime.Today; }); } }
public static void PrintDonators() { using (var db = new DonatorContext()) { var donators = db.Donators.Where(p => p.ProvinceId == 2);//找出河北省的打赏者 foreach (var donator in donators) { Console.WriteLine(donator.Name + "\t" + donator.Amount + "\t" + donator.DonateDate); } } }
public static void 另一种视图查询() { using (var db = new DonatorContext()) { var sql = @"select donatorid,donatorname,amount,donatedate,provincename from dbo.donatorviews where provincename={0}"; var donatorsViaCommand = db.Database.SqlQuery<DonatorViewInfo>(sql, "河北省"); foreach (var donator in donatorsViaCommand) { Console.WriteLine(donator.ProvinceName + "\t" + donator.DonatorId + "\t" + donator.DonatorName + "\t" + donator.Amount + "\t" + donator.DonateDate); } } }
public static void 视图查询() { using (var db = new DonatorContext()) { var donators = db.DonatorViews; foreach (var donatorViewInfo in donators) { Console.WriteLine(donatorViewInfo.ProvinceName + "\t" + donatorViewInfo.DonatorId + "\t" + donatorViewInfo.DonatorName + "\t" + donatorViewInfo.Amount + "\t" + donatorViewInfo.DonateDate); } } Console.WriteLine("视图查询"); }
public static void 另一种视图查询() { using (var db = new DonatorContext()) { var sql = @"select donatorid,donatorname,amount,donatedate,provincename from dbo.donatorviews where provincename={0}"; var donatorsViaCommand = db.Database.SqlQuery <DonatorViewInfo>(sql, "河北省"); foreach (var donator in donatorsViaCommand) { Console.WriteLine(donator.ProvinceName + "\t" + donator.DonatorId + "\t" + donator.DonatorName + "\t" + donator.Amount + "\t" + donator.DonateDate); } } }
public static void 视图查询() { using (var db = new DonatorContext()) { var donators = db.DonatorViews; foreach (var donatorViewInfo in donators) { Console.WriteLine(donatorViewInfo.ProvinceName + "\t" + donatorViewInfo.DonatorId + "\t" + donatorViewInfo.DonatorName + "\t" + donatorViewInfo.Amount + "\t" + donatorViewInfo.DonateDate); } } Console.WriteLine("视图查询"); }
public static void 执行存储过程无返回值() { using (var db = new DonatorContext()) { var sql = "UpdateHeBeiDonator {0},{1}"; FluentConsole.Green.Line("执行存储过程前的数据为:"); PrintDonators(); var rowsAffected = db.Database.ExecuteSqlCommand(sql, "Update", 10m); FluentConsole.Green.Line("影响的行数为{0}条,", rowsAffected); FluentConsole.Green.Line("执行存储过程之后的数据为:"); PrintDonators(); } }
public static void 从存储过程中查询() { using (var db = new DonatorContext()) { var sql = "SelectDonators {0}"; var donators = db.Database.SqlQuery<DonatorFromStoreProcedure>(sql, "山东省"); foreach (var donator in donators) { FluentConsole.Green.Line(donator.ProvinceName + "\t" + donator.Name + "\t" + donator.Amount + "\t" + donator.DonateDate); } } Console.WriteLine("从存储过程中获取数据"); }
public static void 从存储过程中查询() { using (var db = new DonatorContext()) { var sql = "SelectDonators {0}"; var donators = db.Database.SqlQuery <DonatorFromStoreProcedure>(sql, "山东省"); foreach (var donator in donators) { FluentConsole.Green.Line(donator.ProvinceName + "\t" + donator.Name + "\t" + donator.Amount + "\t" + donator.DonateDate); } } Console.WriteLine("从存储过程中获取数据"); }
public static void 执行存储过程无返回值() { using (var db = new DonatorContext()) { var sql = "UpdateHeBeiDonator {0},{1}"; FluentConsole.Green.Line("执行存储过程前的数据为:"); PrintDonators(); var rowsAffected = db.Database.ExecuteSqlCommand(sql, "Update", 10m); FluentConsole.Green.Line("影响的行数为{0}条,", rowsAffected); FluentConsole.Green.Line("执行存储过程之后的数据为:"); PrintDonators(); } }
public static async Task 异步遍历查询结果() { using (var db = new DonatorContext()) { await db.Donators.ForEachAsync(d => { d.DonateDate = DateTime.Today; }); } }
public static async Task<int> 异步聚合函数() { using (var db = new DonatorContext()) { return await db.Donators.CountAsync(); } }
public static async Task<Donator> 异步定位一条记录(int donatorId) { using (var db = new DonatorContext()) { return await db.Donators.FindAsync(donatorId); //return await db.Donators.FirstAsync(donatorId); } }
public static void PrintDonators() { using (var db = new DonatorContext()) { var donators = db.Donators.Where(p => p.ProvinceId == 2);//找出河北省的打赏者 foreach (var donator in donators) { Console.WriteLine(donator.Name + "\t" + donator.Amount + "\t" + donator.DonateDate); } } }
public static async Task<IEnumerable<Donator>> 异步查询对象列表() { using (var db = new DonatorContext()) { return await db.Donators.ToListAsync(); } }
public static async Task 异步创建对象(Donator donator) { using (var db = new DonatorContext()) { db.Donators.Add(donator); await db.SaveChangesAsync(); } }