FluentDb 1.0.6

FluentDb FTLab Fintech

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.

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

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

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.6 282 11/12/2017
1.0.5 211 10/20/2017
1.0.4 198 10/20/2017
1.0.3 202 10/20/2017
1.0.1 207 10/18/2017
1.0.0 207 10/16/2017