CA.Blocks.SqliteDataAccess 3.6.200

👁 NuGet version (CA.Blocks.DataAccess)
👁 Build Status

• 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}");
 }