Aranasoft.Cobweb.EntityFrameworkCore.Validation
1.80.0
Prefix Reserved
dotnet add package Aranasoft.Cobweb.EntityFrameworkCore.Validation --version 1.80.0
NuGet\Install-Package Aranasoft.Cobweb.EntityFrameworkCore.Validation -Version 1.80.0
<PackageReference Include="Aranasoft.Cobweb.EntityFrameworkCore.Validation" Version="1.80.0" />
paket add Aranasoft.Cobweb.EntityFrameworkCore.Validation --version 1.80.0
#r "nuget: Aranasoft.Cobweb.EntityFrameworkCore.Validation, 1.80.0"
// Install Aranasoft.Cobweb.EntityFrameworkCore.Validation as a Cake Addin #addin nuget:?package=Aranasoft.Cobweb.EntityFrameworkCore.Validation&version=1.80.0 // Install Aranasoft.Cobweb.EntityFrameworkCore.Validation as a Cake Tool #tool nuget:?package=Aranasoft.Cobweb.EntityFrameworkCore.Validation&version=1.80.0
Aranasoft.Cobweb.EntityFramework.Validation
Schema validation and testing components for Entity Framework Core.
Cobweb was created by Arana Software, a software agency in Las Vegas, Nevada.
Details
A utility for Entity Framework Core. It includes a schema validation tool that can be used to validate the schema of a database against the schema of an Entity Framework Core DbContext
.
Validations
Tables
- Table presence
- Column presence
- Column type
- Column nullability
- Column default values (Entity Framework Core 3.x and later)
Views (Entity Framework Core 3.x and later)
- View presence
- Column presence
- Column type
- Column nullability
Indexes
- Index presence
- Index uniqueness (Entity Framework Core 3.x and later)
Foreign Keys
- Foreign Key presence
Installation
From Package Manager Console:
PM> install-package aranasoft.cobweb.entityframeworkcore.validation
From .NET CLI:
> dotnet add package aranasoft.cobweb.entityframeworkcore.validation
Usage
// using Aranasoft.Cobweb.EntityFrameworkCore.Validation
myApplicationContext.ValidateSchema([options]);
ValidateSchema
requires that the DbContext
uses an
Application Service Provider configured with platform-specific design
time services.
Example:
var serviceCollection = new ServiceCollection().AddEntityFrameworkDesignTimeServices();
new SqlServerDesignTimeServices().ConfigureDesignTimeServices(serviceCollection);
var serviceProvider = serviceCollection.BuildServiceProvider();
var builder = new DbContextOptionsBuilder<ApplicationDbContext>();
builder.UseSqlServer(myConnection);
builder.UseApplicationServiceProvider(serviceProvider);
var myApplicationContext = new ApplicationDbContext(builder.Options);
Options
// using Aranasoft.Cobweb.EntityFrameworkCore.Validation
var options = new SchemaValidationOptions{
ValidateIndexes = true,
ValidateForeignKeys = true
};
ValidateIndexes
Type: boolean
<br>
Default: true
Set to false
to skip validation of indexes.
ValidateForeignKeys
Type: boolean
<br>
Default: true
Set to false
to skip validation of foreign keys. Useful for platforms that do no use foreign keys.
ValidateNullabilityForTables
Type: boolean
<br>
Default: true
Set to false
to skip validation of nullability on table columns.
ValidateNullabilityForViews
Type: boolean
<br>
Default: false
Set to false
to skip validation of nullability on view columns. By default, many database platforms enable nullability on view columns regardless of nullability on the underlying table column.
This option is not applicable to Entity Framework Core 2.x or Aranasoft.Cobweb.EntityFrameworkCore.Validation 1.2x.x.
License
Cobweb is copyright of Arana Software, released under the BSD License.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
-
net8.0
- Microsoft.EntityFrameworkCore.Design (>= 8.0.0 && < 9.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.80.0 | 202 | 3/20/2024 |
1.70.0 | 174 | 3/20/2024 |
1.60.2 | 160 | 3/20/2024 |
1.60.1 | 3,980 | 6/20/2022 |
1.60.0 | 1,492 | 1/25/2022 |
1.50.5 | 151 | 3/20/2024 |
1.50.4 | 806 | 6/20/2022 |
1.50.3 | 888 | 1/22/2022 |
1.50.2 | 920 | 1/22/2022 |
1.50.1 | 861 | 1/21/2022 |
1.30.7 | 173 | 3/20/2024 |
1.30.6 | 937 | 6/20/2022 |
1.30.5 | 871 | 1/22/2022 |
1.30.4 | 1,241 | 10/30/2020 |
1.30.3 | 951 | 9/16/2020 |
1.30.2 | 1,268 | 4/14/2020 |
1.30.0 | 938 | 4/9/2020 |
1.20.7 | 155 | 3/20/2024 |
1.20.6 | 873 | 6/20/2022 |
1.20.5 | 859 | 1/22/2022 |
1.20.4 | 923 | 10/30/2020 |
1.20.2 | 938 | 4/14/2020 |
1.20.0 | 1,782 | 12/10/2019 |
1.20.0-preview-10501 | 815 | 12/5/2019 |
CHANGELOG.md