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); }