C# (CSharp) FOReserva.DataAccess.DataAccessObject.Common DAOの例

コード例 #1

ファイル: TestDAO.cs プロジェクト: vpineda7/Reserva

        public void TestDAOExecuteNoQuery()
        {
            var       instanceDAO = new FOReserva.DataAccess.DataAccessObject.Common.DAO();
            DAOResult result      = null;

            result = instanceDAO.OpenConnection();
            Debug.WriteLine(String.Format("Message OpenConnection: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);

            result = instanceDAO.ExecuteNoQuery(String.Format(@"INSERT INTO dbo.TableForTUnit VALUES ('TestRevision at {0}')", DateTime.Now.ToString("dd/MM/yyyy")));
            Debug.WriteLine(String.Format("Message ExecuteQuery: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);

            result = instanceDAO.CloseConnection();
            Debug.WriteLine(String.Format("Message CloseConnection: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);
        }

コード例 #2

ファイル: TestDAO.cs プロジェクト: vpineda7/Reserva

        public void TestDAOExecuteStoreProcedure()
        {
            var       instanceDAO = new FOReserva.DataAccess.DataAccessObject.Common.DAO();
            DAOResult result      = null;

            result = instanceDAO.OpenConnection();
            Debug.WriteLine(String.Format("Message OpenConnection: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);

            result = instanceDAO.ExecuteStoreProcedure("M20_TestProcedure", new { thisAt = DateTime.Now.ToString("dd/MM/yyyy") });
            Debug.WriteLine(String.Format("Message ExecuteQuery: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);

            result = instanceDAO.CloseConnection();
            Debug.WriteLine(String.Format("Message CloseConnection: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);
        }

コード例 #3

ファイル: TestDAO.cs プロジェクト: vpineda7/Reserva

        public void TestDAOExecuteQuery()
        {
            var       instanceDAO = new FOReserva.DataAccess.DataAccessObject.Common.DAO();
            DAOResult result      = null;

            result = instanceDAO.OpenConnection();
            Debug.WriteLine(String.Format("Message OpenConnection: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);

            result = instanceDAO.ExecuteQuery(@"SELECT 'ok' AS ""output""", doThis: (reader) => {
                var output = reader.GetString(0);
                Debug.WriteLine(String.Format("Data from DB: {0}", output));
            });
            Debug.WriteLine(String.Format("Message ExecuteQuery: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);

            result = instanceDAO.CloseConnection();
            Debug.WriteLine(String.Format("Message CloseConnection: {0}", result.Message));
            Assert.IsTrue(result.ProcessFinishCorrectly);
        }