BinaryCoffee.AnyDataBaseFluent 1.2.0

.NET 6.0 
dotnet add package BinaryCoffee.AnyDataBaseFluent --version 1.2.0
NuGet\Install-Package BinaryCoffee.AnyDataBaseFluent -Version 1.2.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="BinaryCoffee.AnyDataBaseFluent" Version="1.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add BinaryCoffee.AnyDataBaseFluent --version 1.2.0
#r "nuget: BinaryCoffee.AnyDataBaseFluent, 1.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// 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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • 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