Geek Answers Handbook

What is the assembly for connecting MySQL for a universal application

I want to build a database connection using the MySQL Connector. I get a connection to the assembly MySql.Data.RT.dll , but that was for Win RT. Is this also correct for a universal Win 10 application, or is it better to use one of the .NET 4.5 Framework:

enter image description here

My question is:

What assembly to choose for the universal Windows application?

+6
source share
2 answers

MySql connection happens through

MySql.Data and MySql.Data.MySqlClient

these two assemblies are most often used by DLL files for any mysql connections.

Sample code in C #:

  MySqlConnection MYSQLCON; MySqlDataAdapter daDataAdapter; MySqlCommand MYSQLCmd; public MYSQLDataAccess() { ConnectionStrinG = getMySqlConnectionString(); MYSQLCON = new MySqlConnection(ConnectionStrinG); } public string getMySqlConnectionString() { string CString = ConfigurationManager.AppSettings["MyCString"].ToString(); // Connection string from web.config string ConStr = ConfigurationManager.ConnectionStrings[CString].ToString(); return ConStr; }
+2
source

I think you should use the SQLite.Net-PCL library. He will add two links

  • SQLite.Net
  • SQLite.Net.Platform.WinRT

You can refer to this URL http://igrali.com/2015/05/01/using-sqlite-in-windows-10-universal-apps/

SQLite is a software library that implements a stand-alone, serverless, zero configuration, transactional mechanism of SQL DBMS. This package contains the SDK extension and all other components necessary for using SQLite to develop UAP applications with Visual Studio 2015. For more information, including full documentation, see the official website http://www.sqlite.org/ .

If you use RTM for Visual Studio 2015 and the SDK 10240, now there is an official (no more preliminary release) SQLite VSIX package that can be downloaded from SQLite.org. Find the Universal Application Platform and you're ready to go! The rest of the blog post should also apply to this version.

-one
source

More articles:


All Articles