예제 #1
0
파일: UT_GPL.cs 프로젝트: iturribeitia/GPL
        public void Extensions_T004_IDataReader_ToDelimitedFile()
        {
            const long RowsToRead = 50;

            string CmdText = "select top " + RowsToRead.ToString() + " * from [Northwind].[dbo].[Customers]";

            const int BufferSize = 1024 * 4;

            const string TestFile = "c:\\temp\\test.csv";

            //var Provider = DBHelper.Providers.OleDB;   // 12 sec
            var Provider = DBHelper.Providers.SqlServer; // 08 sec
            //var Provider = DBHelper.Providers.ODBC; // 20 sec

            string Cnstring = string.Empty;

            switch (Provider)
            {
            case DBHelper.Providers.SqlServer:
                //Cnstring = SQL_PROD_CONNECTIONSTRING;
                Cnstring = SQL_SQLSERVER_LOCALDB_CONNECTIONSTRING;

                break;

            case DBHelper.Providers.OleDB:
                Cnstring = SQL_OLEDB_LOCALDB_CONNECTIONSTRING;
                break;

            case DBHelper.Providers.ODBC:
                Cnstring = SQL_ODBC_LOCALDB_CONNECTIONSTRING;
                break;

            case DBHelper.Providers.Oracle:
                break;

            default:
                break;
            }

            long FileRows = 0;

            // create a connection object
            using (var dbh = new DBHelper(false))
            {
                dbh.CreateDBObjects(Cnstring, Provider, null);

                DbDataReader rdr = (DbDataReader)Utility.RetryMethod(new Func <string, CommandType, ConnectionState, DbDataReader>(dbh.ExecuteReader), 3, 3, CmdText, CommandType.Text, ConnectionState.Open);

                FileRows = rdr.ToDelimitedFile(TestFile, false, Encoding.Default, BufferSize, true, textQualifier: "\"", columnDelimiter: "|");
            }

            var r = File.Exists(TestFile);

            Assert.IsInstanceOfType(r, typeof(bool));
            Assert.AreEqual(true, r);
            Assert.AreEqual(RowsToRead, FileRows);
        }
예제 #2
0
파일: UT_GPL.cs 프로젝트: iturribeitia/GPL
        public void Utility_T004_RetryMethod()
        {
            const long RowsToRead = 90;

            string CmdTextOK    = "select top " + RowsToRead.ToString() + " * from [Northwind].[dbo].[Customers]";
            string CmdTextWRONG = "select top " + RowsToRead.ToString() + " * [Northwind].[dbo].[XXXX]";


            //var Provider = DBHelper.Providers.OleDB;   // 12 sec
            var Provider = DBHelper.Providers.SqlServer; // 08 sec
            //var Provider = DBHelper.Providers.ODBC; // 20 sec

            string Cnstring = string.Empty;

            switch (Provider)
            {
            case DBHelper.Providers.SqlServer:
                Cnstring = SQL_SQLSERVER_LOCALDB_CONNECTIONSTRING;
                break;

            case DBHelper.Providers.OleDB:
                Cnstring = SQL_OLEDB_LOCALDB_CONNECTIONSTRING;
                break;

            case DBHelper.Providers.ODBC:
                Cnstring = SQL_ODBC_LOCALDB_CONNECTIONSTRING;
                break;

            case DBHelper.Providers.Oracle:
                break;

            default:
                break;
            }

            // create a connection object
            using (var dbh = new DBHelper(false))
            {
                dbh.CreateDBObjects(Cnstring, Provider, null);

                // Example without retries.
                //var rdr = dbh.ExecuteReader(CmdText, CommandType.Text, ConnectionState.Open);

                // Example with retries defining the delegate before and invoking in the Utility.RetryMethod note that the return type 'DataSet' is declared at the end, and the parameters types before.
                var     newfuction = new Func <string, CommandType, ConnectionState, DataSet>(dbh.GetDataSet); // You can define the delegate before or inside of the RetryMethod.
                DataSet rdr        = (DataSet)Utility.RetryMethod(newfuction, 3, 3, CmdTextOK, CommandType.Text, ConnectionState.Open);
                //rdr = (DataSet)Utility.RetryMethod(newfuction, 3, 3, CmdTextWRONG, CommandType.Text, ConnectionState.Open);

                // Example with retries defining the delegate inside and imvoking the Utility.RetryMethod note that the return type 'DbDataReader' is declared at the end and the parameters types before.
                // DbDataReader rdr = (DbDataReader)Utility.RetryMethod(new Func<string, CommandType, ConnectionState, DbDataReader>(dbh.ExecuteReader), 3, 3, CmdTextOK, CommandType.Text, ConnectionState.Open);

                Assert.IsInstanceOfType(rdr, typeof(DataSet));
                Assert.AreEqual(RowsToRead, rdr.Tables[0].Rows.Count);
            }
        }