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);
}
