コード例 #1
0
ファイル: _BaseRepository.cs プロジェクト: quangphat/TmTech
        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();
        }
コード例 #2
0
ファイル: DbConnectionData.cs プロジェクト: quangphat/TmTech
        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);
        }