C# (CSharp) MVC5AdoDataAccess AdoDataService Examples

Example #1

File: AdoCustomerService.cs Project: Malkiat-Singh/MVC5_WebAPI2_KnockoutJS_Demo

        private void ShrinkDatabase()
        {
            AdoDataService dataService = new AdoDataService();

            dataService.CreateSession();

            SqlCommand sqlCommand;
            string     sql = string.Empty;

            sql = "DBCC SHRINKDATABASE (MVC5Database,10)";

            sqlCommand             = new SqlCommand();
            sqlCommand.Connection  = dataService.dbConnection;
            sqlCommand.CommandText = sql;
            sqlCommand.ExecuteNonQuery();

            dataService.CloseSession();
        }

Example #2

File: AdoCustomerService.cs Project: Malkiat-Singh/MVC5_WebAPI2_KnockoutJS_Demo

        private void ShrinkDatabase()
        {
            AdoDataService dataService = new AdoDataService();

            dataService.CreateSession();

            SqlCommand sqlCommand;
            string sql = string.Empty;

            sql = "DBCC SHRINKDATABASE (MVC5Database,10)";

            sqlCommand = new SqlCommand();
            sqlCommand.Connection = dataService.dbConnection;
            sqlCommand.CommandText = sql;
            sqlCommand.ExecuteNonQuery();

            dataService.CloseSession();
        }