public void delete_with_schema_both_from_fluent_API_and_default() { using (var db = new FluentApiDefaultSchemaContext("someDefaultSchema", "someApiSchema")) { var sql = db.Posts .Where(x => x.Id == 1) .GenerateBulkDeleteSql(); // Fluent API takes precedence over default Assert.Equal(@"DELETE FROM [someApiSchema].[Posts] WHERE [Posts].[Id] = 1;", sql, false, true, false); } }
public void update_with_schema_both_from_fluent_API_and_default() { using (var db = new FluentApiDefaultSchemaContext("someDefaultSchema", "someApiSchema")) { var sql = db.Posts .Where(x => x.Id == 1) .SetField(x => x.IsPinned).WithValue(true) .SetField(x => x.IsHighlighted).WithValue(true) .GenerateBulkUpdateSql(); // Fluent API takes precedence over default Assert.Equal(@"UPDATE [someApiSchema].[Posts] SET [Posts].[IsPinned] = {0}, [Posts].[IsHighlighted] = {1} WHERE [Posts].[Id] = 1;", sql, false, true, false); } }