FluentDb 1.0.6

Install-Package FluentDb -Version 1.0.6
dotnet add package FluentDb --version 1.0.6
<PackageReference Include="FluentDb" Version="1.0.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add FluentDb --version 1.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: FluentDb, 1.0.6"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install FluentDb as a Cake Addin
#addin nuget:?package=FluentDb&version=1.0.6

// Install FluentDb as a Cake Tool
#tool nuget:?package=FluentDb&version=1.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Welcome to FluentDb

Данная сборка предоставляет методы расширяющие объекты ADO.NET

пример использования

using (var db = new SQLiteConnection("Data Source=:memory:"))
{
    db.Connect()
    .ExecuteNonQuery(cmd =>
        cmd.SetCommandText("SELECT @Id, @Code")
           .SetCommandTimeout(TimeSpan.FromSeconds(5))
           .AddParameter("Id", 0L)
           .AddParameter(p => p.SetName("Code")
                               .SetDbType(DbType.String)
                               .SetValue("Hello")));
}

Примеры

1. Bag of parameters

db.ExecuteNonQuery(
    cmdText: "INSERT INTO MYTABLE VALUES (@Id, @Code)"
  , bag: new { Id = 1, Code = "Код" });

2. ExecuteNonQuery

db.ExecuteNonQuery("CREATE TABLE MYTABLE(Id, Code)");

3. ExecuteScalar

var value = await db.ExecuteScalarAsync<long>("SELECT 4");

4. ExecuteReader

//преобразование
var rows = db.AsEnumerable(
       commandText: "SELECT 1, 'Hello' UNION ALL SELECT 2, 'World'"
     , map: r => new { Id = r.GetInt64(0), Value = r.GetString(1) })
     .ToArray();
//автоматическое преобразование
var entities = db.AsEnumerable<Entity>(
       commandText: "SELECT 1 as Id, 'Hello' as Name")
     .ToArray();

NuGet packages (1)

Showing the top 1 NuGet packages that depend on FluentDb:

Package Downloads
FluentDb.Sql

FluentDb.Sql FTLab Fintech

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.6 806 11/12/2017
1.0.5 670 10/20/2017
1.0.4 582 10/20/2017
1.0.3 711 10/20/2017
1.0.1 565 10/18/2017
1.0.0 590 10/16/2017