本文整理汇总了C#中CaptureSqlFilter类的典型用法代码示例。如果您正苦于以下问题：C#CaptureSqlFilter类的具体用法？C#CaptureSqlFilter怎么用？C#CaptureSqlFilter使用的例子？这里精选的类代码示例或许可以为您提供帮助。 示例1:Can_capture_command_Select_APIs publicvoidCan_capture_command_Select_APIs() { using(varcaptured=newCaptureSqlFilter()) using(vardb=OpenDbConnection()) { inti=0; i++;db.Select(x=>x.Age>40); varp=OrmLiteConfig.UseParameterizeSqlExpressions ?"@0"//Normalized :"40"; Assert.That(captured.SqlCommandHistory.Last().Sql.NormalizeSql(), Is.EqualTo("selectid,firstname,lastname,agefrompersonwhere(age>{0})".Fmt(p))); i++;db.Select(q=>q.Where(x=>x.Age>40)); i++;db.Select(db.From().Where(x=>x.Age>40)); i++;db.Select("Age>40"); i++;db.Select("SELECT*FROMPersonWHEREAge>40"); i++;db.Select("Age>@age",new{age=40}); i++;db.Select("SELECT*FROMPersonWHEREAge>@age",new{age=40}); i++;db.Select("Age>@age",newDictionary{{"age",40}}); i++;db.SelectFmt("Age>{0}",40); i++;db.SelectFmt("SELECT*FROMPersonWHEREAge>{0}",40); i++;db.Where("Age",27); i++;db.Where(new{Age=27}); i++;db.SelectByIds(new[]{1,2,3}); i++;db.SelectByIds(new[]{1,2,3}); i++;db.SelectNonDefaults(newPerson{Id=1}); i++;db.SelectNonDefaults("Age>@Age",newPerson{Age=40}); i++;db.SelectLazy().ToList(); i++;db.WhereLazy(new{Age=27}).ToList(); i++;db.Select(); i++;db.Single(x=>x.Age==42); i++;db.Single(db.From().Where(x=>x.Age==42)); i++;db.Single(new{Age=42}); i++;db.Single("Age=@age",new{age=42}); i++;db.SingleById(1); i++;db.SingleWhere("Age",42); i++;db.Exists(new{Age=42}); i++;db.Exists("SELECT*FROMPersonWHEREAge=@age",new{age=42}); i++;db.ExistsFmt("Age={0}",42); i++;db.ExistsFmt("SELECT*FROMPersonWHEREAge={0}",42); Assert.That(captured.SqlCommandHistory.Count,Is.EqualTo(i)); captured.SqlCommandHistory.PrintDump(); } }
原文链接：http://www.jxszl.com/biancheng/C/556670.html