public void Test2() { DbEntry.From <Article>().Where(p => p.Title.StartsWith("tom")).Select(); AssertSql("SELECT [Id],[Title],[User_Id] AS [User] FROM [Article] WHERE [Title] LIKE @Title_0;\n<Text><60>(@Title_0=tom%:String)"); }
public void TestNotIn() { DbEntry.From <SinglePersonSqlite>().Where(CK.K["Id"].NotIn(1, 3, 5, 7)).Select(); AssertSql(@"SELECT [Id],[Name] FROM [People] WHERE [Id] NOT IN (@in_0,@in_1,@in_2,@in_3); <Text><60>(@in_0=1:Int32,@in_1=3:Int32,@in_2=5:Int32,@in_3=7:Int32)"); }
public void Test1() { var list = DbEntry.From<JoinClass>().Where(Condition.Empty).Select(); Assert.IsNotNull(list); Assert.AreEqual(0, list.Count); }
public void Test3() { Assert.AreEqual(3, DbEntry.From <Category>().Where(Condition.Empty).GetCount()); Assert.AreEqual(5, DbEntry.From <Book>().Where(Condition.Empty).GetCount()); Assert.AreEqual(2, DbEntry.From <Book>().Where(CK.K["Category_Id"] == 3).GetCount()); }
public void TestUpperForLike() { DbEntry.From <SinglePersonSqlite>().Where(CK.K["Name"].ToUpper().Like("%tom%")).Select(); AssertSql(@"SELECT [Id],[Name] FROM [People] WHERE UPPER([Name]) LIKE @Name_0; <Text><60>(@Name_0=%tom%:String)"); }
public void TestGroupBy() { DbEntry.From <SoftDeleteSqlite>().Where(Condition.Empty).GroupBy <string>("tom"); Assert.AreEqual("SELECT [tom],COUNT([tom]) AS it__count__ FROM [SoftDelete] WHERE [IsDeleted] = @IsDeleted_0 GROUP BY [tom];\n<Text><60>(@IsDeleted_0=False:Boolean)", StaticRecorder.LastMessage); }
public void TestJoinTableNoCreate() { DbEntry.From <JoinTableNoCreate>().Where(Condition.Empty).Select(); }
public void Test6() { DbEntry.From <PersonSqlite>().Where(Condition.Empty).OrderByDescending(p => p.FirstName).ThenBy(p => p.Id).Select(); Assert.AreEqual("SELECT [Id],[Name] AS [FirstName] FROM [People] ORDER BY [Name] DESC,[Id] ASC;\n<Text><60>()", StaticRecorder.LastMessage); }
public void TestLowerFunction() { DbEntry.From <PersonSqlite>().Where(p => p.FirstName.ToLower() == "tom").Select(); AssertSql(@"SELECT [Id],[Name] AS [FirstName] FROM [People] WHERE LOWER([Name]) = @Name_0; <Text><60>(@Name_0=tom:String)"); }
public void TestNotNull() { StaticRecorder.ClearMessages(); DbEntry.From <PropertyClassWithDbColumnSql>().Where(CK.K["Name"] != null).Select(); Assert.AreEqual("SELECT [Id],[Name] AS [TheName] FROM [People] WHERE [Name] IS NOT NULL;\n<Text><60>()", StaticRecorder.LastMessage); }
public void Test3() { DbEntry.From <PersonSqlite>() .Where(p => p.FirstName.Contains("T")).Select(); Assert.AreEqual("SELECT [Id],[Name] AS [FirstName] FROM [People] WHERE [Name] LIKE @Name_0;\n<Text><60>(@Name_0=%T%:String)", StaticRecorder.LastMessage); }
public void Test2NdPageWithSqlserver2005WithAlias() { StaticRecorder.ClearMessages(); DbEntry.From <FieldPersonSql>().Where(CK.K["Age"] > 18).OrderBy("Id").Range(3, 5).Select(); Assert.AreEqual("SELECT [Id],[TheName] FROM (SELECT [Id],[Name] AS [TheName], ROW_NUMBER() OVER ( ORDER BY [Id] ASC) AS __rownumber__ FROM [People] WHERE [Age] > @Age_0) AS T WHERE T.__rownumber__ >= 3 AND T.__rownumber__ <= 5 ORDER BY T.__rownumber__;\n<Text><60>(@Age_0=18:Int32)", StaticRecorder.LastMessage); }
public void TestSelect() { DbEntry.From <PeopleModel2>().Where(CK.K["Name"] == "tom" && CK.K["Age"] > 18).Select(); Assert.AreEqual("SELECT \"ID\",\"NAME\" FROM \"PEOPLE\" WHERE (\"NAME\" = @Name_0) AND (\"AGE\" > @Age_1);<Text><60>(@Name_0=tom:String,@Age_1=18:Int32)", StaticRecorder.LastMessage); }
public void Test3() { DbEntry.From <Article>().Where(p => p.Title.ToLower() == "tom").Select(); AssertSql("SELECT [Id],[Title],[User_Id] AS [User] FROM [Article] WHERE LOWER([Title]) = @Title_0;\n<Text><60>(@Title_0=tom:String)"); }
public void TestDelete1() { DbEntry.From <TestClass>().Where(p => p.Name == "abc").Delete(); AssertSql(@"DELETE FROM [Test_Class] WHERE [Name] = @Name_0; <Text><30>(@Name_0=abc:String)"); }
public void TestUpperForLike() { DbEntry.From <PersonSqlite>().Where(p => p.FirstName.ToUpper().Contains("tom")).Select(); AssertSql(@"SELECT [Id],[Name] AS [FirstName] FROM [People] WHERE UPPER([Name]) LIKE @Name_0; <Text><60>(@Name_0=%tom%:String)"); }
public void TestCount() { long n = DbEntry.From <SoftDelete>().Where(Condition.Empty).GetCount(); Assert.AreEqual(3, n); }
public void TestEnum() { DbEntry.From <EnumTest>().Where(p => p.Abc == MyEnum.Test1).Select(); AssertSql("SELECT [Id],[ccc] AS [Abc] FROM [Enum_Test] WHERE [ccc] = @ccc_0;\n<Text><60>(@ccc_0=0:Int32)"); }
public List <T> Find(Expression <Func <T, bool> > condition) { return(DbEntry.From <T>().Where(condition).OrderBy(_order).Select()); }
public void TestBoolOfDefault() { DbEntry.From <BoolTest>().Where(p => p.Available).Select(); AssertSql("SELECT [Id],[Name],[Available] FROM [Bool_Test] WHERE [Available] = @Available_0;\n<Text><60>(@Available_0=True:Boolean)"); }
public void TestPartOf() { DbEntry.From <DtPart>().Where(Condition.Empty).Select(); AssertSql(@"SELECT [Id],[dtValue] FROM [DateAndTime]; <Text><60>()"); }
public void TestBoolOfDefault2() { DbEntry.From <BoolTest>().Where(p => p.Available && p.Name == "tom").Select(); AssertSql("SELECT [Id],[Name],[Available] FROM [Bool_Test] WHERE ([Available] = @Available_0) AND ([Name] = @Name_1);\n<Text><60>(@Available_0=True:Boolean,@Name_1=tom:String)"); }
public void TestUpperFunction() { DbEntry.From <SinglePersonSqlite>().Where(CK.K["Name"].ToUpper() == "tom").Select(); AssertSql(@"SELECT [Id],[Name] FROM [People] WHERE UPPER([Name]) = @Name_0; <Text><60>(@Name_0=tom:String)"); }
public void TestInClause() { DbEntry.From <BoolTest>().Where(p => p.Id.In(1, 3, 5, 7)).Select(); AssertSql("SELECT [Id],[Name],[Available] FROM [Bool_Test] WHERE [Id] IN (@in_0,@in_1,@in_2,@in_3);\n<Text><60>(@in_0=1:Int64,@in_1=3:Int64,@in_2=5:Int64,@in_3=7:Int64)"); }
public void TestInSql() { DbEntry.From <SinglePersonSqlite>().Where(CK.K["Id"].InSql("Select Id From Others")).Select(); AssertSql(@"SELECT [Id],[Name] FROM [People] WHERE [Id] IN (Select Id From Others); <Text><60>()"); }
public void TestNotIn2() { DbEntry.From <BoolTest>().Where(CK.K["Id"].NotIn(1, 3, 5, 7)).Select(); AssertSql("SELECT [Id],[Name],[Available] FROM [Bool_Test] WHERE [Id] NOT IN (@in_0,@in_1,@in_2,@in_3);\n<Text><60>(@in_0=1:Int32,@in_1=3:Int32,@in_2=5:Int32,@in_3=7:Int32)"); }
public void TestNotIn2() { DbEntry.From <SinglePersonSqlite>().Where(CK.K["Name"].NotIn("Tom", "Jerry")).Select(); AssertSql(@"SELECT [Id],[Name] FROM [People] WHERE [Name] NOT IN (@in_0,@in_1); <Text><60>(@in_0=Tom:String,@in_1=Jerry:String)"); }
public void TestNotIn3() { DbEntry.From <BoolTest>().Where(CK.K["Name"].NotIn("Tom", "Jerry")).Select(); AssertSql("SELECT [Id],[Name],[Available] FROM [Bool_Test] WHERE [Name] NOT IN (@in_0,@in_1);\n<Text><60>(@in_0=Tom:String,@in_1=Jerry:String)"); }
public void TestLazyLoadFieldForCondition2() { DbEntry.From <lzpUserSqlite>().Where(p => p.Profile == "test").Select(); AssertSql("SELECT [Id],[Name] FROM [lzp_User_Sqlite] WHERE [Profile] = @Profile_0;\n<Text><60>(@Profile_0=test:String)"); }
public void Test1() { DbEntry.From <Article>().Where(p => p.User.Value.Id.In(1)).Select(); AssertSql("SELECT [Id],[Title],[User_Id] AS [User] FROM [Article] WHERE [User_Id] IN (@in_0);\n<Text><60>(@in_0=1:Int64)"); }