public void delete_with_schema_both_from_data_annotation_and_default() { using (var db = new DataAnnotationDefaultSchemaContext("someDefaultSchema")) { var sql = db.Products .Where(x => x.Id == 1) .GenerateBulkDeleteSql(); // Data annotation takes precedence over default Assert.Equal(@"DELETE FROM [someAttributeSchema].[Products] WHERE [Products].[Id] = 1;", sql, false, true, false); } }
public void update_with_schema_both_from_data_annotation_and_default() { using (var db = new DataAnnotationDefaultSchemaContext("someDefaultSchema")) { var sql = db.Products .Where(x => x.Id == 1) .SetField(x => x.Name).WithValue("some name") .SetField(x => x.Description).WithValue("some description") .GenerateBulkUpdateSql(); // Data annotation takes precedence over default Assert.Equal(@"UPDATE [someAttributeSchema].[Products] SET [Products].[Name] = {0}, [Products].[Description] = {1} WHERE [Products].[Id] = 1;", sql, false, true, false); } }