public static List <String> ChatId()
//создает лист с колонкой ChatId(номер чата) из ChatRelation
{
List <string> ChatId = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM ChatRelation";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var chatid = dt.Columns["ChatID"];
foreach (DataRow dr in dt.Rows)
{
ChatId.Add(dr[chatid].ToString());
}
connection.Close();
}
catch { }
return(ChatId);
}
public AddResources(SQLiteConnection sql)
{
fact = new SQLiteFactory();
command = sql.CreateCommand();
this.sql = sql;
}
//create database with profiles (if not exixsts) and open window to create profile
private void button_create_profile_Click(object sender, EventArgs e)
{
if (!File.Exists(db_name))
{
SQLiteConnection.CreateFile(db_name);
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = "Data Source = " + db_name;
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "CREATE TABLE IF NOT EXISTS [profiles] (" +
"[id] INTEGER PRIMARY KEY AUTOINCREMENT," +
"[login] TEXT," +
"[password] TEXT" +
")";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
connection.Close();
}
}
//open window to create new profile
Form_Creare_Profile new_form = new Form_Creare_Profile();
new_form.ShowDialog();
}
public fmDB(bool _bSilent = false)
{
bSilent = _bSilent;
if (bSilent)
{
if (!EventLog.SourceExists(source))
{
EventLog.CreateEventSource(source, "Application");
}
}
try
{
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
}
catch (Exception ex)
{
if (!bSilent)
{
MessageBox.Show("Не установлен System.Data.SQLite (1.0.103)" + Environment.NewLine + ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
EventLog.WriteEntry(source, "Не установлен System.Data.SQLite(1.0.103)", EventLogEntryType.Error);
}
Application.Exit();
}
}
public static List <String> ContactIdMsg()
//создает лист с колонкой ContactId(номер пользователя) из MessageInfo
{
List <string> ContactIdMsg = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM MessageInfo ORDER BY TimeStamp";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var contactid = dt.Columns["ContactID"];
foreach (DataRow dr in dt.Rows)
{
ContactIdMsg.Add(dr[contactid].ToString());
}
connection.Close();
}
catch { }
return(ContactIdMsg);
}
protected virtual void InitializeAndBuildTable()
{
if (File.Exists(FileName))
{
File.Delete(FileName);
}
DbProviderFactory fact = new SQLiteFactory();
m_dbConnection = fact.CreateConnection();
if (m_dbConnection == null)
{
return;
}
m_dbConnection.ConnectionString = "Data Source=" + FileName;
try
{
m_dbConnection.Open();
}
catch (Exception ex)
{
Logger.Instance.AddEntry("SQLitePeakListExporter failed. Details: " + ex.Message, true);
throw;
}
BuildTable();
}
public static List <String> Default()
{
List <string> def = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM Accounts";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var num = dt.Columns["IsDefault"];
foreach (DataRow dr in dt.Rows)
{
def.Add(dr[num].ToString());
}
connection.Close();
}
catch { }
return(def);
}
static void Main(string[] args)
{
string baseName = "playerdb.db3";
SQLiteConnection.CreateFile(baseName);
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = "Data Source = " + baseName;
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = @"CREATE TABLE [players] (
[id] integer PRIMARY KEY NOT NULL,
[xcoordinate] integer NOT NULL,
[ycoordinate] integer NOT NULL,
[size] integer NOT NULL
);";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
}
}
public static BindingSource DownloadBD()
{
try
{
DataColumn column = new DataColumn {
AutoIncrementSeed = 1L,
AutoIncrement = true,
ColumnName = "№"
};
dt.Columns.Add(column);
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection)
{
CommandText = "SELECT * FROM Accounts",
CommandType = CommandType.Text
};
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
connection.Close();
}
catch
{
}
return(bs);
}
public static bool TrySQLiteCommandExecute(string _DBFilename, string CommandText)
{
bool error = false;
try
{
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = "Data Source = " + _DBFilename;
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = @CommandText;
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
error = true;
}
return(!error);
}
private void CreateDB()
{
string Name = ConfigurationSettings.AppSettings.Get("DB_Name");
SQLiteConnection.CreateFile(Name);
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectStr"].ConnectionString.ToString();
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = @"CREATE TABLE [Files] (
[id] integer PRIMARY KEY AUTOINCREMENT NOT NULL,
[FileName] char(100) NOT NULL,
[Data] Blob NOT NULL
);"; // varchar(MAX) → error
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
}
}
public static List <String> TimeStamps()
//Создает лист TimeStamps, содержащий время отправки и получения сообщений в unix времени
// Встроен конвертер unixtime в обычное время
{
List <string> TimeStamps = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM MessageInfo ORDER BY TimeStamp";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var TimeStamp = dt.Columns["TimeStamp"];
foreach (DataRow dr in dt.Rows)
{
TimeStamps.Add(dr[TimeStamp].ToString());
}
connection.Close();
}
catch { }
return(TimeStamps);
}
public static BindingSource DownloadBD()
{
try
{
DataColumnCollection columns = WorkBD.dt.Columns;
DataColumn column = new DataColumn();
column.AutoIncrementSeed = 1L;
int num = 1;
column.AutoIncrement = num != 0;
string str = "№";
column.ColumnName = str;
columns.Add(column);
WorkBD.factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
WorkBD.connection = (SQLiteConnection)WorkBD.factory.CreateConnection();
WorkBD.connection.ConnectionString = "Data Source = " + WorkBD.path_config;
WorkBD.connection.Open();
SQLiteCommand sqLiteCommand = new SQLiteCommand(WorkBD.connection);
sqLiteCommand.CommandText = "SELECT * FROM Accounts";
sqLiteCommand.CommandType = CommandType.Text;
sqLiteCommand.ExecuteNonQuery();
WorkBD.sql.SelectCommand = sqLiteCommand;
WorkBD.sql.Fill(WorkBD.dt);
WorkBD.bs.DataSource = (object)WorkBD.dt;
WorkBD.connection.Close();
}
catch
{
}
return(WorkBD.bs);
}
public static List <String> IdMes()
//создает лист c информацией о сообщении
{
List <string> IdMes = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM MessageInfo ORDER BY TimeStamp";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var type = dt.Columns["EventID"];
foreach (DataRow dr in dt.Rows)
{
IdMes.Add(dr[type].ToString());
}
connection.Close();
}
catch { }
return(IdMes);
}
public static List <String> ViberContacts()
//Создает лист ViberContacts , в котором указано, использует ли контакт Viber; 1-использует, 0 - не использует
{
List <string> ViberContacts = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM Contact";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var ViberContact = dt.Columns["ViberContact"];
foreach (DataRow dr in dt.Rows)
{
ViberContacts.Add(dr[ViberContact].ToString());
}
connection.Close();
}
catch { }
ViberContacts.RemoveAt(0);
return(ViberContacts);
}
public Database(string file, string checkSql, string createSql)
{
if (file == null)
{
throw new ArgumentNullException("file");
}
if (checkSql == null)
{
throw new ArgumentNullException("checkSql");
}
if (createSql == null)
{
throw new ArgumentNullException("createSql");
}
var dir = new System.IO.FileInfo(file).Directory;
if (!dir.Exists)
{
dir.Create();
}
factory = new SQLiteFactory();
Connection = (SQLiteConnection)factory.CreateConnection();
Connection.ConnectionString = "Data Source=" + file;
Connection.Open();
if (!CheckValidity(checkSql))
{
CreateTables(createSql);
}
}
public static long LastMessageTime()
//создает лист c информацией о сообщении
{
List <string> LastMessageTime = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = CheckMessage.db";
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM Message";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var type = dt.Columns["Time"];
foreach (DataRow dr in dt.Rows)
{
LastMessageTime.Add(dr[type].ToString());
}
connection.Close();
}
catch { }
return(Convert.ToInt64(LastMessageTime.Last()));
}
public static List <String> Avatars()
//создает лист аватарами
{
List <string> Avatars = new List <string>();
try
{
DataTable dt = new DataTable();
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM Contact";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var type = dt.Columns["DownloadID"];
foreach (DataRow dr in dt.Rows)
{
Avatars.Add(dr[type].ToString());
}
connection.Close();
}
catch { }
Avatars.RemoveAt(0);
return(Avatars);
}
public static List <String> Number()
{
List <string> IDs = new List <string>();
try
{
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + path_config;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = @"SELECT * FROM Accounts";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
sql.SelectCommand = command;
sql.Fill(dt);
bs.DataSource = dt;
var ID = dt.Columns["ID"];
foreach (DataRow dr in dt.Rows)
{
IDs.Add(dr[ID].ToString());
}
connection.Close();
}
catch { }
return(IDs);
}
public void SQLConnect(string baseName, out string exept)
{
//string baseName = "CompanyWorkers.db3";
try
{
SQLiteConnection.CreateFile(baseName);
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
exept = "\nCreate db file corect\n";
try
{
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + baseName;
connection.Open();
command = new SQLiteCommand(connection);
exept = "\nConect to db corect\n";
}
catch (Exception ex2)
{
exept = "\n" + ex2.Message + "\n";
}
}
catch (Exception ex1)
{
exept = "\n" + ex1.Message + "\n";
}
}
public Database()
{
// Initialize SQLite.
SQLiteConnection.CreateFile(DbName);
// Create connection factory.
_connectionFactory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
}
void OpenConnection()
{
if (factory != null || connection != null)
{
return;
}
factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
connection = (SQLiteConnection)factory.CreateConnection();
connection.ConnectionString = "Data Source = " + DB_PATH;
connection.Open();
}
internal static void ExecuteNonQuery(string command, DbConnection conn, SQLiteFactory factory, DbTransaction trans)
{
using (DbDataAdapter adpt = factory.CreateDataAdapter())
{
using (DbCommand cmd = conn.CreateCommand())
{
cmd.Transaction = trans;
cmd.CommandText = command;
cmd.ExecuteNonQuery();
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try {
SQLiteConnection.CreateFile(dbName);
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
//using(SQLiteFactory factory = (SQLiteFactory) DbProviderFactories.GetFactory("System.Data.SQLite")) {
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection()) {
connection.ConnectionString = $"Data Source = {dbName}";
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection)) {
command.CommandText = @"CREATE TABLE Students (
Id integer PRIMARY KEY AUTOINCREMENT,
FirstName NVARCHAR(32) NOT NULL,
SecondName NVARCHAR(32) NOT NULL,
Course tinyint NOT NULL
);" ;
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
command.CommandText = @"INSERT INTO Students
(FirstName, SecondName, Course)
VALUES
('Dude1', 'Moonlighter', 1),
('Dude2', 'Grayrat', 1),
('Dude3', 'Whitehourse', 1),
('Dude4', 'Nightmarehouse', 2),
('Dude5', 'Redsocks', 2)
" ;
command.ExecuteNonQuery();
command.CommandText = @"INSERT INTO Student
(FirstName, SecondName, Course)
VALUES
('Dude1', 'Moonlighter', 1),
('Dude2', 'Grayrat', 1),
('Dude3', 'Whitehourse', 1),
('Dude4', 'Nightmarehouse', 2),
('Dude5', 'Redsocks', 2)
" ;
}
}
//}
}
catch (Exception ex) {
MessageBox.Show(this, ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
CreateBtn.IsEnabled = false;
LinkBtn.IsEnabled = true;
}
static public List <FullRow> ReadSQLite(SQLiteFactory factory)
{
List <FullRow> result = new List <FullRow>();
string baseName = "inputdatabase.db3";
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = "Data Source = " + baseName;
connection.Open();
try
{
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText =
"select name_model, number_airplane, code_seat, id_seat, " +
"code_airport_in, city_airport_in, country_airport_in, " +
"code_airport_out, city_airport_out, country_airport_out, " +
"number_flight, date_time_flight, number_passenger from [all];";
command.CommandType = CommandType.Text;
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
FullRow info = new FullRow(
reader.GetString(reader.GetOrdinal("name_model")),
reader.GetInt64(reader.GetOrdinal("number_airplane")),
reader.GetString(reader.GetOrdinal("code_seat")),
reader.GetInt64(reader.GetOrdinal("id_seat")),
reader.GetString(reader.GetOrdinal("code_airport_in")),
reader.GetString(reader.GetOrdinal("city_airport_in")),
reader.GetString(reader.GetOrdinal("country_airport_in")),
reader.GetString(reader.GetOrdinal("code_airport_out")),
reader.GetString(reader.GetOrdinal("city_airport_out")),
reader.GetString(reader.GetOrdinal("country_airport_out")),
reader.GetInt64(reader.GetOrdinal("number_flight")),
reader.GetString(reader.GetOrdinal("date_time_flight")),
reader.GetInt64(reader.GetOrdinal("number_passenger")));
result.Add(info);
}
}
}
}
catch (Exception e)
{
Console.WriteLine("Ошибка при чтении SQLite: " + e.Message);
}
connection.Close();
}
return(result);
}
/// <summary>
/// 创建华为备份文件实例
/// </summary>
/// <param name="path"></param>
/// <param name="error"></param>
/// <returns></returns>
public static HbFile Create(string path, Action <ErrorResult> error)
{
try
{
var context = SQLiteFactory.NewContext(path);
var file = new HbFile(context, error);
return(file);
}
catch (Exception e)
{
Logger.Error(e);
return(null);
}
}
private void button1_Click(object sender, EventArgs e)
{
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
SQLiteConnection conn = new SQLiteConnection();
conn.ConnectionString = @"Data Source = " + Data.baseName;
try
{
conn.Open();
}
catch (SQLiteException se)
{
MessageBox.Show("Error: {0}", se.Message);
return;
}
SQLiteCommand login = new SQLiteCommand("Select login, pass From Users", conn);
using (SQLiteDataReader dr = login.ExecuteReader(CommandBehavior.CloseConnection))
{
string user = "";
string password = "";
while (dr.Read())
{
user = dr.GetValue(0).ToString().Trim();
password = dr.GetValue(1).ToString().Trim();
if (p == 0)
{
if (textBox1.Text.ToString().Equals(user) && textBox2.Text.ToString().Equals(password))
{
main main = new main();
main.Show();
this.Hide();
p++;
}
}
}
if (p == 0)
{
MessageBox.Show("Wrong login or password");
}
}
conn.Close();
conn.Dispose();
}
private void LoadLocalization()
{
string path = Environment.ExpandEnvironmentVariables(
@"%USERPROFILE%\AppData\LocalLow\Dire Wolf Digital\The Elder Scrolls_ Legends\LocalizationDB.db");
if (!File.Exists(path))
{
path = Environment.ExpandEnvironmentVariables(
@"%USERPROFILE%\AppData\LocalLow\Dire Wolf Digital\The Elder Scrolls_ Legends\LocalizationDB.Steam.db");
}
SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = "Data Source = " + path;
connection.Open();
SQLiteCommand command = new SQLiteCommand("SELECT * FROM Lookup WHERE \"key\" LIKE \"%-title\" OR \"key\" LIKE \"%-game_text\";", connection);
SQLiteDataReader reader = command.ExecuteReader();
foreach (DbDataRecord record in reader)
{
string id = record["key"].ToString();
if (id.Contains("-title"))
{
id = id.Replace("-title", "");
try{
Card c = FindCardById(Guid.Parse(id));
if (c != Card.Unknown)
{
c.Name = record["value"].ToString();
}
}
catch { }
}
else if (id.Contains("-game_text"))
{
id = id.Replace("-game_text", "");
try
{
Card c = FindCardById(Guid.Parse(id));
if (c != Card.Unknown)
{
c.Text = HtmlToPlainText(record["value"].ToString());
}
}
catch { }
}
}
}
}
private DatabaseManager()
{
this.db_last_msg = string.Empty;
this.sql_conn = new SQLiteConnection(sql_conn_str);
this.sql_adapter = new SQLiteDataAdapter(sql_adapter_str, this.sql_conn);
this.sql_adapter.ContinueUpdateOnError = true; // Ignore errors on failed row update
// Create SQLite command builder for data adapter
SQLiteFactory sql_factory = new SQLiteFactory();
SQLiteCommandBuilder sql_builder = (SQLiteCommandBuilder)sql_factory.CreateCommandBuilder();
sql_builder.SetAllValues = false;
sql_builder.DataAdapter = this.sql_adapter;
this.sql_conn.Open();
}
protected override IDisposable Connect()
{
DbProviderFactory fact = new SQLiteFactory();
SQLiteConnection conn = (SQLiteConnection)fact.CreateConnection();
if (conn != null)
{
var connectionStringBuilder =
SessionFactoryFactory.SQLiteConnectionStringBuilderFromFilePath(FilePath);
connectionStringBuilder.Version = 3;
conn.ConnectionString = connectionStringBuilder.ToString();
conn.Open();
}
return(conn);
}
