Hello, and thank you,
I am developing a module and I would like to use LinqToSQL as my data access layer for updating my user defined table(s) in my DNN Database. I have started this module using the Chris Hammond project template. And I have installed the "source" into my development DotNetNuke website on my local machine.
I have created the LinqToSQL classes in a sub folder called "LinqData" of the "App_Code" folder and I have added the <add directoryName="LinqData" /> element to my web.config.
When trying to access the LinqToSql classes during my development, I am having various crazy Namespace issues. If I open my module project directly, I get "The type or namespace LinqDataContext1 could not be found....." when trying to instantiate a private variable in the View.ascx.cs as:
private LinqDataContext1 db = new LinqDataContext1();
When I open my website that contains the source for this module and I open the View.ascx page (not the code behind) on the line that I define my linq datasource
" <asp:LinqDataSource ID= ... " I get the following message:
Element "LinqDataSource" is not known element.
Where should I create the LinqToSql classes, in the App_Code folder of my website or in a basic subfolder of my module project. I am using DotNetNuke 5.5. Do I need to add any additional "using " references, or do I need to "register" some component at the top of my ASCX file.
Any suggestions and help will be appreciated. I have tried the Michael Washington tutorial on "Creating a Module with LinqToSQL in DNN." That is where I go the idea to put the LinqToSql classes in the App_Code folder, but I'm not sure this is correct in this case.
Thank you so much for your help.
Elgin