Skip to content

kicsiede/SQLite-Net.Extensions.Readers

 
 

Repository files navigation

Build status

SQLite-Net.Extensions.Readers

Extension readers for https://github.com/praeclarum/sqlite-net project.

This extension let to query the database without binding to a specific class. The results are Dictionnary of <string, object>. Each key contains ColumnName, Value contains data.

Platform Support

Platform Available
PCL (Profile 111)

Onboarding Instructions

  1. Add nuget package:

    Install-Package MvvX.Plugins.HockeyApp

  2. In your source file, add the following line in usage declaration section:

    using SQLite_Net.Extensions.Readers;
  3. In your source file, call ExecuteReader method

    var readerResults = connection.ExecuteReader("SQL Query");

Example

void ExecuteCustomQuery(SQLiteConnection connection)
{
	var tableName = "<SetTableName>";
	// Execute reader :
	var readerResults = connection.ExecuteReader("SELECT * FROM " + tableName);
	Console.WriteLine("Read data from table " + tableName);
	// Showing results :
	foreach (var readerItem in readerResults)
		Console.WriteLine(string.Join(";", readerItem.Fields.Select(e => e + ":" + readerItem[e])));
		
	Console.WriteLine("End read data");
}

Support

If you have any questions, problems or suggestions, create an issue.

About

Extension readers for praeclarum/sqlite-net project

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C# 90.8%
  • PowerShell 9.2%