public void TestBuildsManyToManyInsertQuery() { //--Act var query = new SqlServerInsertQueryBuilder().Insert <ClientUser>(); //--Assert Console.WriteLine(query); var queryLines = SplitQuery(query); Assert.AreEqual(new[] { "insert into [Client_User]([ClientId], [UserId], [IsActive])", "values(@ClientId, @UserId, @IsActive);" }, queryLines); }
public void TestBuildsInsertQuery() { //--Act var query = new SqlServerInsertQueryBuilder().Insert <Client>(); //--Assert Console.WriteLine(query); var queryLines = SplitQuery(query); Assert.AreEqual(new[] { "declare @outputResult table(", " [Id] uniqueidentifier,", " [CreatedDateUtc] datetime,", " [ModifiedDateUtc] datetime", ");", "insert into [Client]([CreatedByUserId], [ModifiedByUserId], [Name], [IsActive])", "output inserted.[Id], inserted.[CreatedDateUtc], inserted.[ModifiedDateUtc] into @outputResult([Id], [CreatedDateUtc], [ModifiedDateUtc])", "values(@CreatedByUserId, @ModifiedByUserId, @Name, @IsActive);", "select * from @outputResult;" }, queryLines); }