C# – Connecting SQLite DB

Initiating SQLLite connection

private SQLiteConnection sqlConnection(string path)
{

      SQLiteConnection sql_con;

      sql_con = new SQLiteConnection(@"URI=file:" + path );

      sql_con.Open();
      return sql_con;
}

Calling Method

Using(SQLiteConnection sql_con in sqlConnection(path)){
       //do stuff
} //connection close at this point
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s