C# code snippet?

Question

I have the following SQL statement that I need to run against a SharePoint 2007 content database. 

delete from dbo.alllists where tp_id = '{ED7FE381-1140-4657-8734-7B1D784C7946}'

Since direct manipulation is forbidden I need to do this via code. Any help would be appreciated. My programming skills are a little bit out of date.

Thanks,

 

Answer 1

Essentially....

 

      Guid SiteGuid = new Guid("Your-GUID-HERE...");
      Guid WebGuid = new Guid("Your-GUID-HERE...");
      Guid ListGuid = new Guid("Your-GUID-HERE...");


      using (SPSite oSite = new SPSite(SiteGuid))
      {
        using (SPWeb oWeb = oSite.OpenWeb(WebGuid))
        {
          oWeb.Lists.Delete(ListGuid);
        }
      }
    

This obviously has no error handling but the concept is there.

Answer 2

Perfect, thanks I'll get it a try on my test server.

 

DLDevine

Answer 3

Much easy way is to use Power Shell.

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") 
$site = new-Object Microsoft.SharePoint.SPSite('http://mysite/')
$web = $site.OpenWeb()
$listGuid = New-Object Guid("ED7FE381-1140-4657-8734-7B1D784C7946");
$web.Lists.Delete($listGuid);
$web.Dispose();
$site.Dispose();

---

Oleg

Answer 4

I will agree with Oleg - Powershell is a very good way to do a one time operation like that. If you were looking to write an application that would do that sort of functionality over and over again I would recommend C# then.