Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Mon Mar 7 12:45:14 CST 2011
Hi Doug -- I think I have seen an ASP.NET book with sources where strongly typed datasets were used but I can't find it now. But maybe that was this book: Pro ASP.NET 2.0 E-Commerce in C# 2005 (Expert's Voice in .NET) http://www.amazon.com/ASP-NET-Commerce-2005-Experts-Voice/dp/1590597249/ref= pd_sim_b_8 It does have complete source code and the DAL code does use ADO.NET DataSets but not strongly typed. I have got programmed rather large ASP.NET application - more than 150 webforms with I suppose more than 70-80 heavily related MS SQL tables with millions rows in some of tables, hundreds SPs, ... several thousands C# custom classes, ORM layer etc. and this web application does work well forth year in row with a few support work - the latter mainly being adding new functionality. I have used asp.net development approach described in this book: ASP.NET 2.0 Website Programming: Problem - Design - Solution (Programmer to Programmer) http://www.amazon.com/ASP-NET-2-0-Website-Programming-Programmer/dp/07645846 42/ref=sr_1_2?s=books&ie=UTF8&qid=1299518125&sr=1-2 BTW, the same approach is used in DotNetNuke (but I didn't know that when I have got started to develop my customer web application I mentioned above.)) I have had to develop custom ORM mapping + SQL code generator to implement this approach. But it should be possible to use some existing code generators. This approach looks "low level" and it needs quite some coding (code generators help here) but good news is that it will never get outdated. And here is a book on how to use LINQ 2 SQL for ASP.NET applications (I haven't read and I haven't tried this approach) for the same sample ASP.NET application, which is used in the previously referred book: LINQ-ifying TheBeerHouse: An N-Tier LINQ Web Application with ASP.NET 2.0 Website Programming Problem Design Solution (Wrox Briefs) http://www.amazon.com/LINQ-ifying-TheBeerHouse-Application-Programming-Solut ion/dp/B0026A6AQU/ref=sr_1_106?s=books&ie=UTF8&qid=1299518458&sr=1-106 The most modern approach is to use ADO.NET Entity Framework for DAL as Gustav noted, and when ADO.NET EF is used then it should be possible to map logical/business layer objects to the custom stored procedures, which can insert, update, delete, select data from one or database tables... I haven't yet seen any books where ADO.NET Entity Framework is used with classical WebForms based ASP.NET applications - anybody? Some more information on ADO.NET EF and ASP.NET: - here seems to be a good book on ADO.NET EF: Entity Framework 4.0 Recipes: A Problem-Solution Approach (Expert's Voice in .NET) http://www.amazon.com/Entity-Framework-4-0-Recipes-Problem-Solution/dp/14302 27036/ref=sr_1_168?s=books&ie=UTF8&qid=1299519467&sr=1-168 - and this one "opens secretes" on how to build ultra-fast and robust asp.net applications: Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server [Paperback] http://www.amazon.com/Ultra-Fast-ASP-NET-Build-Ultra-Scalable-Server/dp/1430 223839/ref=sr_1_121?s=books&ie=UTF8&qid=1299518863&sr=1-121 Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: 7 ????? 2011 ?. 6:05 To: dba-VB at databaseadvisors.com Subject: [dba-VB] ASP.Net development Hello All: A lot of the Microsoft sample code for asp.net data access is built using strongly typed tableadapters with the .xsd design surface. I've built two apps using these in the last year, but they seem to be kind of fiddly - they don't work well with multi table update queries, for instance, and they generate a HUGE amount of background source code. It is nice to have the strong typing, however. I have never found any non-Microsoft sample code which uses this technique. Admittedly, most of the sample code in the wild consists of short snippets built to illustrate a single technique, not a complete application. Two questions: 1. Are there developers out there using this approach for real life apps? 2. If not, what do you recommend? Thanks, Doug Steele _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com