Let me start by describing what i've done to setup the enviroment.

1. I'm using visual studio 2005 on a windows 2003 server with the dnn site setup on the local IIS 6.0 server.
2. I've got the Dot Net Nuke source setup then i have a project under the DotNetNuke source solution which is a local website project and contains the live dnn site.
3. I've created a sub directory under appcode called CSharp and added it to the codedom line in web.config.  I've then added a folder with my module name under CSharp.
4. Next I added a dataprovider.cs, modulenameinfo.cs, modulenameController.cs, SqlDataProvider.cs to that folder.
5. Then I created a folder under Desktop Modules that contains my ascx files with the source files. 
6. I filled all the files with the approiate code and references.

First off has anyone managed to impliment a successful module following the above pattern that was not based off a separate project in visual studio?

Let me start by saying that my module loads, and i can enter data into the form and click save.  Using the debugger i've stepped through the code and found that the module throws an exception when trying to load an instance of my sql data provider.  Error Message: The type initializer for 'WSYSA.Modules.Facility.DataProvider' threw an exception.

Here is the debugger exception detail

System.TypeInitializationException was unhandled by user code
  Message="The type initializer for CompanyName.Modules.Facility.DataProvider' threw an exception."
  Source="App_SubCode_CSharp.fviioplt"
  TypeName="CompanyName.Modules.Facility.DataProvider"
  StackTrace:
       at CompanyName.Modules.Facility.DataProvider.Instance()
       at CompanyName.Modules.Facility.FacilityInsuranceApplicationController.Add(FacilityInsuranceApplicationInfo objFacilityInsuranceApplication) in c:\Inetpub\wwwroot\DotNetNuke\WebSite\App_Code\CSharp\Facility\FacilityInsuranceApplicationController.cs:line 24
       at CompanyName.Modules.Facility.ViewFacilityInsuranceApplication.AddApplication(Object sender, EventArgs e) in c:\Inetpub\wwwroot\DotNetNuke\WebSite\DesktopModules\Facility\ViewFacilityInsuranceApplication.ascx.cs:line 75
       at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
       at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

then the inner exception is "Value cannot be null.\r\nParameter name: type"

All my code is in the namespace CompanyName.Modules.Facility.  Has anyone else ran into this issue.  Do I need to make a separate project for my SQL data provider?