BinaryCoffee.AnyDataBaseFluent
1.2.0
dotnet add package BinaryCoffee.AnyDataBaseFluent --version 1.2.0
NuGet\Install-Package BinaryCoffee.AnyDataBaseFluent -Version 1.2.0
<PackageReference Include="BinaryCoffee.AnyDataBaseFluent" Version="1.2.0" />
paket add BinaryCoffee.AnyDataBaseFluent --version 1.2.0
#r "nuget: BinaryCoffee.AnyDataBaseFluent, 1.2.0"
// Install BinaryCoffee.AnyDataBaseFluent as a Cake Addin
#addin nuget:?package=BinaryCoffee.AnyDataBaseFluent&version=1.2.0
// Install BinaryCoffee.AnyDataBaseFluent as a Cake Tool
#tool nuget:?package=BinaryCoffee.AnyDataBaseFluent&version=1.2.0
AnyDataBaseFluent
AnyDataBaseFluent is a library to fluently create a number of different database types.
Currently supported databases are:
- Access
- Firebird
- MySQL
- Oracle
- PostgreSQL
- SQLite
- SQLServer
<pre><code> DatabaseFactory.Create( databaseType ).WithName( "AnyBusiness" ).UsingSchema( "Test" ).HasTable( table ⇒ table.WithName( "Companies" ).HasColumn( column ⇒ column.WithName( "Id" ).OfType( SqlDbType.Int ).IsAutoIncrementing() .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.NotNull ) ) .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.PrimaryKey ).WithName( "PK_Companies_Id" ) ) ) .HasColumn( column ⇒ column.WithName( "Name" ).OfType( SqlDbType.NVarChar, 100 ) .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.NotNull ) ) ) ) .HasTable( table ⇒ table .WithName( "AnyEmployees" ) .HasColumn( column ⇒ column.WithName( "Id" ).OfType( SqlDbType.Int ).IsAutoIncrementing() .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.NotNull ) ) .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.PrimaryKey ).WithName( "PK_Employees_Id" ) ) ) .HasColumn( column ⇒ column.WithName( "CompanyId" ).OfType( SqlDbType.Int ) .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.NotNull ) ) .HasConstraint( constraint ⇒ constraint.WithName( "FK_Employees_CompanyId" ).OfType( ConstraintType.ForeignKey ).HasReferenceTo( "Companies", "Id" ) ) ) .HasColumn( column ⇒ column.WithName( "Name" ).OfType( SqlDbType.NVarChar, 50 ) .HasConstraint( constraint ⇒ constraint.OfType( ConstraintType.NotNull ) ) ) .HasColumn( column ⇒ column.WithName( "Bio" ).OfType( SqlDbType.NVarChar, ColumnSize.Max ) ) ).Write( writer ); </code></pre>
Creates the script:
<pre><code> USE [Business]
CREATE TABLE [Test].[Companies] ( [Id] INT IDENTITY NOT NULL CONSTRAINT [PK_Companies_Id] PRIMARY KEY, [Name] NVARCHAR ( 100 ) NOT NULL, )
CREATE TABLE [Test].[Employees] ( [Id] INT IDENTITY NOT NULL CONSTRAINT [PK_Employees_Id] PRIMARY KEY, [CompanyId] INT NOT NULL CONSTRAINT [FK_Employees_CompanyId] FOREIGN KEY REFERENCES [Test].[Companies] ( [Id] ), [Name] NVARCHAR ( 50 ) NOT NULL, [Bio] NVARCHAR ( MAX ), ) </code></pre>
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. 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. |
-
net6.0
- No dependencies.
-
net7.0
- No dependencies.
-
net8.0
- No dependencies.
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.2.0 | 184 | 3/25/2023 |
-Update icon
-Update properties in the csproj