public static string getdefaultsqliteconnectionstring()
{
sqliteconnectionstringdto _connectionstringdto = new sqliteconnectionstringdto();
_connectionstringdto.sqlite_database_path = System.Configuration.ConfigurationManager.AppSettings["sqlite_database_path"];
_connectionstringdto.database = System.Configuration.ConfigurationManager.AppSettings["sqlite_database"];
_connectionstringdto.sqlite_db_extension = System.Configuration.ConfigurationManager.AppSettings["sqlite_db_extension"];
_connectionstringdto.sqlite_version = System.Configuration.ConfigurationManager.AppSettings["sqlite_version"];
_connectionstringdto.sqlite_pooling = System.Configuration.ConfigurationManager.AppSettings["sqlite_pooling"];
_connectionstringdto.sqlite_fail_if_missing = System.Configuration.ConfigurationManager.AppSettings["sqlite_fail_if_missing"];
string CONNECTION_STRING = buildsqliteconnectionstringfromobject(_connectionstringdto);
return(CONNECTION_STRING);
}
static string buildsqliteconnectionstringfromobject(sqliteconnectionstringdto _connectionstringdto)
{
string base_dir = Environment.CurrentDirectory;
string database_dir = base_dir + _connectionstringdto.sqlite_database_path;
string dbname = _connectionstringdto.database;
string database_version = _connectionstringdto.sqlite_version;
string db_extension = _connectionstringdto.sqlite_db_extension;
dbname = dbname + "." + db_extension + database_version;
if (!Directory.Exists(database_dir))
{
return(null);
}
else
{
}
string full_database_name_with_path = database_dir + dbname;
string _secure_path_name_response = _connectionstringdto.sqlite_database_path + dbname;
if (!File.Exists(full_database_name_with_path))
{
return(null);
}
else
{
}
string CONNECTION_STRING = @"Data Source=" + full_database_name_with_path + ";" +
"Version=" + _connectionstringdto.sqlite_version + ";" +
"Pooling=" + _connectionstringdto.sqlite_pooling + ";" +
"FailIfMissing=" + _connectionstringdto.sqlite_fail_if_missing;
return(CONNECTION_STRING);
}
