Exemplos de Pomelo.EntityFrameworkCore2_1.Lolita.SqlServer.Tests FluentApiDefaultSchemaContext em C# (CSharp)

Exemplo n.º 1

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

Exemplo n.º 2

Arquivo: UpdateTests.cs Projeto: graemechristie/Lolita

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