CA.Blocks.DataAccess.Extensions.Translators.Json 3.4.147

• Homepage
• Documentation
• NuGet Package Sqlite
• Source Code

This Package is a extension to the DataAccess Blocks targeting the Sqllite provider

Quick example

poco object

    public class sqliteMaster
    {
        public string name { get; set; }
        public string type { get; set; }
        public int rootpage { get; set; }
        public string sql { get; set; }
    }

The Data access class

    public class YourDataAccessClass : SqliteDataAccess.SqliteDataAccess
    {
        public YourDataAccessClass(): base(new SimpleConnectionStringDataAccessConfig("Data Source=.\\fileName.db"))
        {
        }

        public IList<sqliteMaster> GetSqlliteMasterObjects()
        {
	        var cmd = CreateTextCommand("Select * from sqlite_master");
	        return Execute(cmd).ToListOf<sqliteMaster>();
		}

        public async Task<IList<sqliteMaster>> GetSqlliteMasterObjects()
        {
	        var cmd = CreateTextCommand("Select * from sqlite_master");
	        return await ExecuteAsync(cmd).ToListOf<sqliteMaster>();
		}

    }

Calling the data access class

    var instance = new YourDataAccessClass();
    var results  = instance.GetSqlliteMasterObjects();
    foreach (var o in results)
    {
        Console.WriteLine($"{o.name},{o.type},{o.rootpage},{o.sql}");
    }