Part 2: Data Access Layerhttp://www.asp.netWed, 10 Oct 2012 20:35:55 GMTumbracoComments for Part 2: Data Access LayerenComment Posted by pblack777http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Thu, 29 Jul 2010 11:19:59 GMT00000000-0000-0000-000000009673So under the "Adding the Data Access Layer" it says: "For customer information we'll use the standard ASP.NET Membership database. For our shopping cart and product catalog we'll implement a SQL Express database as follows."

So does this database already exist? If so, it would be nice to know.

Anyone?

]]>Comment Posted by pblack777http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Thu, 29 Jul 2010 14:04:34 GMT00000000-0000-0000-000000009675This is poorly written tutorial. Major steps are left out. I had to download the database and figure out how to open it in my project. Some Gotha's along the way like when I try to connect to a .mdb file from the Server Explorer, it doesn't read any folders under "My Documents". I'm assuming that it is a permissions issue. I had to move my project under my C:\ drive. I finally, after some frustration, got it working.

]]>Comment Posted by auroralrhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Tue, 21 Sep 2010 02:08:32 GMT00000000-0000-0000-0000000010324so easy~

]]>Comment Posted by mubarak_100http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Thu, 07 Oct 2010 09:33:16 GMT00000000-0000-0000-0000000010530Hi

In vs2010 I do not see ado.net entity data model among "add new item" selections. I added the existing database that is in the given application.

I do not see how can I follow the steps in this page?

thanks

]]>Comment Posted by tmathewshttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Wed, 03 Nov 2010 14:55:57 GMT00000000-0000-0000-0000000010813This tutorial does leave major steps out. You can get the data from the sample code, but my version of VS 2010 cannot open it! There are also many typos and unclear references throughout.

]]>Comment Posted by dhassenhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Sun, 07 Nov 2010 08:55:14 GMT00000000-0000-0000-0000000010853Massive steps left out of every section of this tutorial. Poor effort and unlike the usual offerings from Joe and ASP.net. I'm creating the db copying the model above, but then when I get to the next step, there are views and stored procedutres we need to include that aren't even mentioed earlier! Oh and lesson one was just as poor, 'add the styles we need' or somthing similar, what styles? which files, give me the code we need to use! Poor, poor, poor.

]]>Comment Posted by phil-khttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Sun, 07 Nov 2010 10:44:49 GMT00000000-0000-0000-0000000010855You are right dhassen, some major steps were left out. My advice to you tho is: consider concentrating on functionality of the tutorial, not styling ( since styles won't add any functionality). I think that's the author's approach, which is why he's probably not explaining the css in details.

Good luck man!..

]]>Comment Posted by wmshh8http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Thu, 30 Dec 2010 20:42:59 GMT00000000-0000-0000-0000000011367I do not see ado.net entity data model among "add new item" selections. I added the existing database that is in the given application.

]]>Comment Posted by JoeStagnerhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Wed, 23 Feb 2011 13:44:39 GMT00000000-0000-0000-0000000012201Guys - please work from the PDF document (downloaded from CodePlex) it was updated some time ago. I'll work with the ASP.NET Site team to get these pages up dated.

]]>Comment Posted by vswamy2011http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Mon, 05 Sep 2011 06:53:58 GMT00000000-0000-0000-0000000014123I am new to asp.net. I have started working on this sample application. But I am struck at opening commerce.mdf. I am unable to open it becuase of errors. I have installed MS Sql Server 2008 (full) as well as MS Sql Server 2008 Express SP1. Appreciate your help.

]]>Comment Posted by LynxCathttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Fri, 18 Nov 2011 19:09:37 GMT00000000-0000-0000-0000000014660I am also new to asp.net. I generated the database, but had proplems elsewhere: To generate the database, please take the following steps, and let me knw where you are getting errors, or where you need more detailed information:

1. Right click App_Data in the solution explorer. Then Add New Item. Choose SQL Server Database. Name the new database Commerce.mdf.

2. Expand The Commerce.mdf folder. Right click Tables, and then Add New Table.

3. Generate Categories, Products, Reviews, ShoppingCart, Orders and OrderDetails tables, as shown in the diagram in the beginning of this tutorial. Set all primary key ID numbers as identity columns, with Identity Increment and Identity seed both equal to 1.

4. Right click Database Diagrams in the database explorer, and then Add New diagram. Select all of the tables to be included in the database diagram.

5. Set up all of the primary key - Foriegn key relationships, as shown in the diagram in the beginning of this tutorial.

I ran into problems when I ADO.NET Entity Data Model. Everything went well, until I got to the final step. The demo shows three views, and one stored procedure that were not available to me, because there was no instruction on how to create them.

Any further details on how to create these views and stored procedure would be greatly appreciated.

]]>Comment Posted by ecnetworkhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Tue, 07 Feb 2012 09:09:27 GMT00000000-0000-0000-0000000014782JoeStagner: You made reference to a PDF document on CodePlex. Could you please tell us where to find this document and/or post a link? Much appreciated.

]]>Comment Posted by ecnetworkhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Tue, 07 Feb 2012 09:12:27 GMT00000000-0000-0000-0000000014783The files you need are located here: tailspinspyworks.codeplex.com/

]]>Comment Posted by moh28eghttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Sat, 18 Feb 2012 00:53:15 GMT00000000-0000-0000-0000000014869I did all the steps until (Installed Template) I did not find the ADO.NET C# Entity Data model.

I tried to install online template I have chosen from online template(Ado.net C# poco Entity Generator but I faced one error and 5 warring the the Entity Data model wizard in PDF to choose connection not appear. I hope anybody to help me in this problem

thank you at advance

]]>Comment Posted by Monkeyfist1830http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Fri, 29 Jun 2012 14:08:40 GMT00000000-0000-0000-0000000015883Where can we get the specs to build the commerce.mdf DB? I an building it and I am having to guess the data types OR is there a download I am missing?

]]>Comment Posted by Monkeyfist1830http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Fri, 29 Jun 2012 14:12:23 GMT00000000-0000-0000-0000000015884Disregard...found it, sorry, I could not remove my post.

]]>Comment Posted by vcdeveloper1http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Thu, 02 Aug 2012 12:58:43 GMT00000000-0000-0000-0000000016104Hi,

Thanks for taking the time to teach us how to be successful in creating web application!.. :)

You didn't show how to create the commerc.mdf in detail before creating EDM_Commerce model. Yes, I do have the downloaded project, but it would be more help to show a beginner how you created tables.

I couldn't create the table myself fields, because you did show each properties. So I was forced to use your project database instead in order to conplete this portion of the tutorial.

If this was the purpse then if should be mention here. I was a little confused at this portion of the tutorial.

]]>Comment Posted by hstandleyhttp://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-2Wed, 10 Oct 2012 20:35:55 GMT00000000-0000-0000-0000000016602Tried to create the db was not successful.

]]>