Web config
<connectionStrings> <add name="ConSql" connectionString="Data Source=.; Initial Catalog=yourdbName; Integrated security=SSPI;" providerName="System.Data.SqlClient" /> <add name="ConSQLite" connectionString="Data Source=.\Mydb.db;" providerName="System.Data.SqlClient" /> </connectionStrings>
Class
using System; using System.Configuration; using System.Data.SqlClient; using System.Data.SQLite; public class Connections { public static SqlConnection GetConnection() { SqlConnection connection; try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString); con.Open(); connection = con; } catch (Exception ex) { throw new Exception(ex.Message); } return connection; } public static SQLiteConnection GetSqliteConnection() { SQLiteConnection connection; try { SQLiteConnection con = new SQLiteConnection(ConfigurationManager.ConnectionStrings["ConSQLite"].ConnectionString); con.Open(); connection = con; } catch (Exception ex) { throw new Exception(ex.Message); } return connection; } }

0 Comments