Chapter 17 The very first Try it out.

hully333 · January 5th, 2011, 07:32 AM

Hi, My first thread and i hope you can help.

The first try it out : Creating A Dynamic Data LINQ to SQL Web Site.

STEP 4 : When i right-click the solution name to add an "App_Code" folder there is no option to do so.

From the menu list of "Add ASP.NET Folder" i only have the following options;
App_GlobalResources
App_LocalResources
App_data (greyed out as its already added)
Browsers
Theme

Any ideas?

Also, Step 3 adding the pubs.mdf to the App_data folder. I had to stop SQL server to accomplish this. Am i right in thinking that's the only way to do it? as its not ideal.

Many thanks in advance

hully333 · January 7th, 2011, 11:34 AM

Ok, I have created a new folder manually and called it App_Code, when created it didnt look like the normal yellow folder, it had a bitmap more inline with the other special folders so that seems ok now. However a further problem i just cant get my head around yet ;

STEP 8 amending the global.asax file.
I have made the changes according to the steps, but i am seeing an error saying that "Type PubsDataContext is not defined".

Code:

 DefaultModel.RegisterContext(GetType(PubsDataContext), New ContextConfiguration() With {.ScaffoldAllTables = True})

Any help will be appreciated as this single problem has stopped me in my tracks.

hully333 · January 9th, 2011, 05:22 PM

Having had another look at it ;

The App_code folder contains ;
Pubs.dbml
which in turn contains ;
Pubs.designer.vb
Within that code there is a partial public class called PubsDataContext

Code:

<Global.System.Data.Linq.Mapping.DatabaseAttribute(Name:="pubs")> _
Partial Public Class PubsDataContext
    Inherits System.Data.Linq.DataContext

However as stated in my previous post, i am seeing an error within default.asax.vb saying that PubsDataContext is not defined.

Any help would be appreciated.

Thanks in advance

hully333 · January 10th, 2011, 10:51 AM

Ok, Its now sorted. When I created the new project I chose Web Application from the start page, instead of File-New Web Site. So there are subtle differences using the DynamicData Webs between WebApps and WebSites.

Thanks for all the help.