MarcTron.Sqlite 1.1.1

MtSql Plugin for Xamarin and Windows

This plugin, built on top of the Sqlite-net library, allows you to add a SqLite database to your projects with a sigle line of code

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

SqlLite Plugin for Xamarin

It is avery intuitive Plugin to use SqlLite on Xamarin. It requires only 1 line of code.

What is this repository for?

You can learn more about SqlLite and this plugin on https://www.xamarinexpert.it/blog/sqlite-made-easy/

LINKS

Available on Nuget: https://www.nuget.org/packages/MarcTron.Sqlite
Project website: http://www.xamarinexpert.it/plugins/mt-sqlite/
Tutorial: https://www.xamarinexpert.it/blog/sqlite-made-easy/
To report any issue: https://bitbucket.org/marcojak81/mtsql

SETUP

Install into your PCL/.NetStandard project and Client projects.
The nuget package will automatically install the sqlite-net-pcl package version 1.5.231

HOT TO USE IT

To get the connection to your Sql database you just need to add this line:

SQLiteConnection conn = MTSql.Current.GetConnection("yourdatabasename.db3");

in case you want to use an async connection you can use:

SQLiteAsyncConnection conn MTSql.Current.GetConnectionAsync("yourdatabasename.db3");

Remember to include the MTSql library with this code (usually it's added automatically):

using MarcTron.Plugin;

RELEASE NOTES

Version 1.1.1
New method added: GetDatabaseAsStream("yourdatabasename.db3");
This method returns your database file as a Stream. For example you can use it if you want to do a backup of your database.

Version 1.1
This version has been rewritten using multi-targeting.
Sqlite-net-pcl updated to version 1.5.231

Supported Platforms

  • Android
  • iOS
  • UWP
  • Windows

CONTACT ME

If you have suggestions or if you would like to see new features added to the plugin, let me know adding an issue on bitbucket or writing a comment on the blog tutorial

SqlLite Plugin for Xamarin

It is avery intuitive Plugin to use SqlLite on Xamarin. It requires only 1 line of code.

What is this repository for?

You can learn more about SqlLite and this plugin on https://www.xamarinexpert.it/blog/sqlite-made-easy/

LINKS

Available on Nuget: https://www.nuget.org/packages/MarcTron.Sqlite
Project website: http://www.xamarinexpert.it/plugins/mt-sqlite/
Tutorial: https://www.xamarinexpert.it/blog/sqlite-made-easy/
To report any issue: https://bitbucket.org/marcojak81/mtsql

SETUP

Install into your PCL/.NetStandard project and Client projects.
The nuget package will automatically install the sqlite-net-pcl package version 1.5.231

HOT TO USE IT

To get the connection to your Sql database you just need to add this line:

SQLiteConnection conn = MTSql.Current.GetConnection("yourdatabasename.db3");

in case you want to use an async connection you can use:

SQLiteAsyncConnection conn MTSql.Current.GetConnectionAsync("yourdatabasename.db3");

Remember to include the MTSql library with this code (usually it's added automatically):

using MarcTron.Plugin;

RELEASE NOTES

Version 1.1.1
New method added: GetDatabaseAsStream("yourdatabasename.db3");
This method returns your database file as a Stream. For example you can use it if you want to do a backup of your database.

Version 1.1
This version has been rewritten using multi-targeting.
Sqlite-net-pcl updated to version 1.5.231

Supported Platforms

  • Android
  • iOS
  • UWP
  • Windows

CONTACT ME

If you have suggestions or if you would like to see new features added to the plugin, let me know adding an issue on bitbucket or writing a comment on the blog tutorial

Release Notes

Version 1.1.1
New method added: GetDatabaseAsStream("yourdatabasename.db3");
This method returns your database file as a Stream. For example you can use it if you want to do a backup of your database.

Version 1.1
     This version has been rewritten using multitargeting.
     Sqlite-net-pcl updated to version 1.5.231

Version History

Version Downloads Last updated
1.1.1 103 3/19/2019
1.1.0 88 2/26/2019
1.0.1 478 3/28/2018
1.0.0 254 3/2/2018