Skip to content

sqlite.md

Latest commit

 

History

History
59 lines (47 loc) · 1.52 KB

sqlite.md

File metadata and controls

59 lines (47 loc) · 1.52 KB
title SimpleStack - SQLite Setup
hero_title
layout page
hero_image /assets/background.jpg
show_sidebar false
menubar home_menu
tabs database_type_tabs

sqlite{:style="float:right"} Two Provider are supported regarding SQLite

Using Microsoft SQLite

Add packages in your project

dotnet add package SimpleStack.Orm
dotnet add package SimpleStack.Orm.SQLite

Sample usage

using SimpleStack.Orm;
using SimpleStack.Orm.MySQLConnector;

var factory = new OrmConnectionFactory(new SqliteDialectProvider(), "CONNECTION_STRING");

using (var connection = factory.OpenConnection())
{
    // Start Querying Database
    var dogs = await connection.SelectAsync<Dog>(x => x.Age > 20);
}

Using SQLite

Add packages in your project

dotnet add package SimpleStack.Orm
dotnet add package SimpleStack.Orm.SDSQLite

Sample usage

using SimpleStack.Orm;
using SimpleStack.Orm.SDSQLite;

var factory = new OrmConnectionFactory(new SqliteDialectProvider(), "CONNECTION_STRING");

using (var connection = factory.OpenConnection())
{
    // Start Querying Database
    var dogs = await connection.SelectAsync<Dog>(x => x.Age > 20);
}