Simple.Sqlite 0.4.79

A simple to use SqliteWrapper

Install-Package Simple.Sqlite -Version 0.4.79
dotnet add package Simple.Sqlite --version 0.4.79
<PackageReference Include="Simple.Sqlite" Version="0.4.79" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Simple.Sqlite --version 0.4.79
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

.NET Core
NuGet

SqliteWrapper

A very simple Sqlite wrapper to plug spiders with it

How to use:

// Create a new instance
SqliteDB db = new SqliteDB("myStuff.db");

// Create a DB Schema
db.CreateTables()
  .Add<MyData>()
  .Commit();

var d = new MyData()
{
    //fill your object
};
// call INSERT
db.Insert(d);

// use GetAll to retrieve all data
var allData = db.GetAll<MyData>();
// Use queries to get back data
var allBobs = db.ExecuteQuery<MyData>("SELECT * FROM MyData WHERE MyName = @name ", new { name = "bob" });

What this library automates ?

Auto fill parameters

This library provides a Query operation similar to Dapper, it can return a query as an Enumerable of your class

var allData = db.GetAll<MyData>();

And supports objects (even anonymous) as parameters

var allBobs = db.ExecuteQuery<MyData>("SELECT * FROM MyData WHERE MyName = @name ", new { name = "bob" });

Also, it supports easy Insertion

var d = new MyData()
{
    //fill your object
};
// call INSERT
db.Insert(d);

And a VERY efficient, transaction based BulkInsertion

MyData[] lotsOfData = getLotsOfData();

// call INSERT
db.BulkInsert(lotsOfData);

Tip: For multi-million insertion, 5k blocks are a good start point

Migration

This library has a very simple Migration tah can:

  • Create new tables
  • Add columns to existing tables

To update your db schema just call CreateTables() and add your classes with Add&lt;T&gt; and then Commit()

// Create a new instance
SqliteDB db = new SqliteDB("myStuff.db");

// Create a DB Schema
 var migrationResult = db.CreateTables()
                         .Add<MyData>()
                         .Commit();

A TableCommitResult will be returned with all changes made

This command will not migrate DATA only the schema

You can make changes on the table definition before it commits with:

db.CreateTables()
  .Add<MyData>()
  .ConfigureTable(t => { /* change last added table here */ })
  .Add<NextTable>()
  .Commit();

.NET Core
NuGet

SqliteWrapper

A very simple Sqlite wrapper to plug spiders with it

How to use:

// Create a new instance
SqliteDB db = new SqliteDB("myStuff.db");

// Create a DB Schema
db.CreateTables()
  .Add<MyData>()
  .Commit();

var d = new MyData()
{
    //fill your object
};
// call INSERT
db.Insert(d);

// use GetAll to retrieve all data
var allData = db.GetAll<MyData>();
// Use queries to get back data
var allBobs = db.ExecuteQuery<MyData>("SELECT * FROM MyData WHERE MyName = @name ", new { name = "bob" });

What this library automates ?

Auto fill parameters

This library provides a Query operation similar to Dapper, it can return a query as an Enumerable of your class

var allData = db.GetAll<MyData>();

And supports objects (even anonymous) as parameters

var allBobs = db.ExecuteQuery<MyData>("SELECT * FROM MyData WHERE MyName = @name ", new { name = "bob" });

Also, it supports easy Insertion

var d = new MyData()
{
    //fill your object
};
// call INSERT
db.Insert(d);

And a VERY efficient, transaction based BulkInsertion

MyData[] lotsOfData = getLotsOfData();

// call INSERT
db.BulkInsert(lotsOfData);

Tip: For multi-million insertion, 5k blocks are a good start point

Migration

This library has a very simple Migration tah can:

  • Create new tables
  • Add columns to existing tables

To update your db schema just call CreateTables() and add your classes with Add&lt;T&gt; and then Commit()

// Create a new instance
SqliteDB db = new SqliteDB("myStuff.db");

// Create a DB Schema
 var migrationResult = db.CreateTables()
                         .Add<MyData>()
                         .Commit();

A TableCommitResult will be returned with all changes made

This command will not migrate DATA only the schema

You can make changes on the table definition before it commits with:

db.CreateTables()
  .Add<MyData>()
  .ConfigureTable(t => { /* change last added table here */ })
  .Add<NextTable>()
  .Commit();

Release Notes

Paired with commit d03e7bc
https://github.com/RafaelEstevamReis/SqliteWrapper

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Simple.Sqlite:

Package Downloads
RafaelEstevam.Simple.Spider.SqliteStorage
Sqlite-based storage engine to the SimpleSpider See examples and documentation on the GitHub page

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
0.4.79 22 1/15/2021
0.4.68 106 1/6/2021
0.4.63 130 12/30/2020
0.4.43 130 12/21/2020
0.4.29 139 12/19/2020
0.4.24 311 12/19/2020
0.4.21 421 12/19/2020
0.1.1 96 11/5/2020
0.1.0 113 11/5/2020