/// <summary> /// /// </summary> /// <param name="result"></param> /// <returns></returns> private ServerInstance LocalWriteConnectionString(SQLServerInstanceResult result) { MattimonSQLite.SQLiteClientDatabase db = GetLocalDatabase(); db.CreateConnectionStringTable(); string servername = result.ServerName; string instancename = result.InstanceName; string connectionstring = result.ConnectionString; string username = result.Username; string version = result.Version; bool monitored = true; db.InsertConnectionString(connectionstring, servername, instancename, username, version, monitored); DataTable dt = (DataTable)db.SelectConnectionString(servername, instancename); return(new ServerInstance { ServerName = dt.Rows[0]["servername"] as string, InstanceName = dt.Rows[0]["instancename"] as string, ConnectionString = dt.Rows[0]["connectionstring"] as string, User = dt.Rows[0]["user"] as string, Clustered = result.Clustered, Monitored = Convert.ToBoolean(dt.Rows[0]["monitored"]), Version = result.Version }); }
/// <summary> /// /// </summary> /// <param name="serverName"></param> /// <param name="instanceName"></param> /// <returns></returns> private string LocalReadConnectionString(string serverName, string instanceName) { MattimonSQLite.SQLiteClientDatabase db = GetLocalDatabase(); db.CreateConnectionStringTable(); DataTable dt = (DataTable)db.SelectConnectionString(serverName, instanceName); return(dt.Rows[0]["connectionstring"] as string); }