public BaseRepository(/*IDbTransaction transaction*/) { IDbConnectionData connection1 = new DbConnectionData(); DatabaseInfor info = new DatabaseInfor() { ServerName = "192.168.1.41", User = "******", DatabaseName = "TmTech", Password = "******" }; Connection = connection1.CreateConnection(info); Connection.Open(); Transaction = Connection.BeginTransaction(); }
public IDbConnection CreateConnection(DatabaseInfor requestDatabaseInfor) { var connection = string.Format("Data Source={0};Initial Catalog={1};User id={2};Password={3};", requestDatabaseInfor.ServerName, requestDatabaseInfor.DatabaseName, requestDatabaseInfor.User, requestDatabaseInfor.Password); IDbConnection idbConnection = null; try { idbConnection = new SqlConnection(connection); } catch (Exception e) { idbConnection = null; } return(idbConnection); }