通过ADO.NET连接向Microsoft SQL数据库文件发送SHRINK命令

我只将此作为原始SQL发送:

using (SqlCommand command = new SqlCommand("DBCC SHRINKDATABASE(0)", connection))
{
    command.ExecuteNonQuery();
}

另一种方法是 DBCC SHRINKDATABASE 在存储过程中,并从代码中调用存储过程。

谢谢马克,我只是想知道如何获得sqlconnection。 下面是完整的源代码(使用扩展方法可以更好地编写ok):

    public ActionResult Optimize()
    {
        using (BXPartsEntities Entities = new BXPartsEntities())
        {

            System.Data.EntityClient.EntityConnection eConnection = Entities.Connection as System.Data.EntityClient.EntityConnection;

            eConnection.Open();

            var SqlConnection = eConnection.StoreConnection as SqlConnection;

            if (SqlConnection == null)
                throw new ArgumentException("StoreConnection shall be SQL Connection");

            using (SqlCommand command = new SqlCommand("DBCC SHRINKDATABASE(0)", SqlConnection))
            {
                command.ExecuteNonQuery();
            }

            eConnection.Close();
        }
        return Content("Done");
    }