Getting Started with ASP.NET 4.5 Web Forms - Create the Data Access Layerhttp://www.asp.netThu, 25 Apr 2013 17:09:53 GMTumbracoComments for Getting Started with ASP.NET 4.5 Web Forms - Create the Data Access LayerenComment Posted by bfallar3http://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 24 Aug 2012 05:37:19 GMT00000000-0000-0000-0000000016274The ProductDatabaseInitializer custom class does not work with VS 2012 RTM, please refer to this blog to make this work, www.codeguru.com/

]]>Comment Posted by Jason.Redwoodhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerSun, 09 Sep 2012 01:12:03 GMT00000000-0000-0000-0000000016398Copied word for word and I have 9 build errors. I'm using VS 11 RC. Is there a reference or something vital that I require in this version. Errors include:

Error 1 The name 'Database' does not exist in the current context

Error 2 The type or namespace name 'DropCreateDatabaseIfModelChanges' could not be found (are you missing a using directive or an assembly reference?)

Error 3 The best overloaded method match for 'System.Collections.Generic.List<WingtipToys.Models.Category>.ForEach(System.Action<WingtipToys.Models.Category>)' has some invalid arguments

Error 4 Argument 1: cannot convert from 'lambda expression' to 'System.Action<WingtipToys.Models.Category>'

Error 5 The best overloaded method match for 'System.Collections.Generic.List<WingtipToys.Models.Product>.ForEach(System.Action<WingtipToys.Models.Product>)' has some invalid arguments

Error 6 Argument 1: cannot convert from 'lambda expression' to 'System.Action<WingtipToys.Models.Product>'

Error 7 'object' does not contain a constructor that takes 1 arguments

Error 8 The type or namespace name 'DbSet' could not be found (are you missing a using directive or an assembly reference?)

Error 9 The type or namespace name 'DbSet' could not be found (are you missing a using directive or an assembly reference?)

]]>Comment Posted by Jason.Redwoodhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerSun, 09 Sep 2012 01:38:26 GMT00000000-0000-0000-0000000016399Sorted. I found I had to reference the EntityFramework.dll which in installed via NuGet. Cheers

]]>Comment Posted by omer gokcekhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerMon, 10 Sep 2012 08:58:32 GMT00000000-0000-0000-0000000016406This tutorial is really great, compare to the previous one. I would like to ask what to do to populate the data in the sql 2012 management studio instead of a *.mdf file. Will it be enough to change just the web config file?

Kind Regards,

]]>Comment Posted by yomiyusufhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 02 Nov 2012 13:07:55 GMT00000000-0000-0000-0000000016734Hi, Thanks for the tutorial but i have been stuck on the ProductContext.cs. for days. I cannot get it to work.

The DBcontext gets underlined in red (meaning its not a recognized class, i assume)

Wat do i do please.

i use VS 2012 RC

]]>Comment Posted by yomiyusufhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 02 Nov 2012 13:25:38 GMT00000000-0000-0000-0000000016735oops, solved it.

i used the Package Manager Console to get the EntityFramework.

Works like magic.

]]>Comment Posted by jjobcorphttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerTue, 06 Nov 2012 09:28:53 GMT00000000-0000-0000-0000000016751I receive no notice when I try to build and when I run through it in debug, it does not build a database. I suspect this might be because I am using sql express, but am not sure.

]]>Comment Posted by erikreitanhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerTue, 06 Nov 2012 18:06:27 GMT00000000-0000-0000-0000000016753Hi jjobcorp,

The Entity Framework will generate the database when the application is run the first time because the Application_Start method contained in the global.asax.cs file will call the initializer class. The initializer class will use the model classes (Category and Product) that you add during this tutorial series to create the database.

Please take a look at the "Running the Application and Creating the Database" section in the "UI and Navigation" tutorial of this series. Thanks

Erik

]]>Comment Posted by developer_aspxhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 23 Nov 2012 20:45:17 GMT00000000-0000-0000-0000000016868My browser does not show any code highlited in yellow for Global.asax.cs modification even though I am using IE 9. How do I identify the codes?

My error is "BundeConfig and AuthConfig do not exist in the current context.

]]>Comment Posted by BforBrilliancehttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerWed, 05 Dec 2012 13:42:16 GMT00000000-0000-0000-0000000016941In order to add the Reference for System.Data.Entity you have to Right-Click the project name and scroll down to Add Reference. I know that seems like a remedial addition but it took me FOREVER to realize you mean Right-Click YOUR PROJECT TITLE to see the menu where Add Reference is locates.... *sweating at this point lol*

]]>Comment Posted by IbrahimHasanhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerTue, 11 Dec 2012 12:30:45 GMT00000000-0000-0000-0000000016984Thanks to Erik , but i felt its an advanced tutorial .

Hi , Developer_aspx ... I faced the same problem , in Global.asx , add the following lines only , and it will work

using System.Data.Entity;

using WingtipToys.Models;

Database.SetInitializer(new ProductDatabaseInitialize

these are the yellow lines ..

]]>Comment Posted by asadazmathttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 14 Dec 2012 04:28:01 GMT00000000-0000-0000-0000000017003Thanks Erik.

]]>Comment Posted by rschnitzerhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 25 Jan 2013 11:29:52 GMT00000000-0000-0000-0000000018250At this point in the project there are now two database files.

Can you give some direction on how I would integrate the new data model in with the membership database that was originally created?

]]>Comment Posted by WardahKafeelhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerSun, 27 Jan 2013 05:33:44 GMT00000000-0000-0000-0000000018258Are model classes necessory ...? i mean I can add new record and get data from database without model classes.. is this right aproach?

]]>Comment Posted by kevinhagyardhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerWed, 30 Jan 2013 19:31:07 GMT00000000-0000-0000-0000000018285I would have preferred this tutorial (asp.net 4.5) proceed like the version 4.0 one of Tom Dykstra's did, starting with a database and creating the entity framework from it. It seems like a more logical approach to solve an E-Commerce problem with a database first methodology.

]]>Comment Posted by CeeConhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerFri, 01 Mar 2013 23:38:16 GMT00000000-0000-0000-0000000018556You've missed the part of adding a reference to System.Data.Entity in the References folder.

]]>Comment Posted by darrensthttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerThu, 07 Mar 2013 06:19:29 GMT00000000-0000-0000-0000000018599Hi Erik,

This works great with a local DB, however how would we port to a local SQL Server or (in my case) a Azure DB.

Using code first migrations creates the tables but doesn't seed the data.

Any help would be greatly appreciated.

]]>Comment Posted by candidsharphttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerThu, 28 Mar 2013 14:12:24 GMT00000000-0000-0000-0000000018797When I build this I got this error.

Inconsistent accessibility: property type 'WingTipToys.Models.Category' is less accessible than property 'WingTipToys.Models.Product.Category'

Any idea whats wroong?

]]>Comment Posted by candidsharphttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerThu, 28 Mar 2013 14:24:04 GMT00000000-0000-0000-0000000018798Sorry I fixed it... the Category class was not declared as public.

]]>Comment Posted by afiqhttp://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerMon, 08 Apr 2013 12:27:00 GMT00000000-0000-0000-0000000018875I am currently trying to modified the database so that it can calculate stock to. Can you guide me on how to change this database into an inventory stock management... please

]]>Comment Posted by tcm2http://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerThu, 25 Apr 2013 14:29:00 GMT00000000-0000-0000-0000000018982I am having trouble updating the Global.asax.cs file. My specific problem is adding "using WingTipToys.Models;" Models is underlined in red, the only intelisense choice is "Account."

On build the error message says ..."Models" does not exist in the namespace "WingtopToys"... The folder is there and populated per the tutorial.

Also, I ma hand coding into VS2010 because I am not sure I have room for add VS2012 right now.

]]>Comment Posted by tcm2http://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/create_the_data_access_layerThu, 25 Apr 2013 17:09:53 GMT00000000-0000-0000-0000000018985Got it. Used "tmWingtipToys" as the name of my project and hand keyed in most of the tutorial code. But I got to a point where I cut and pasted in some to speed up the process. The cut and paste parts used "WingtipToy" for the namespace.

What I learned here is the folders are part of the namespace used in the classes.

]]>