[dba-VB] ASP.Net development

Hi Shamil:

Thanks very much for your reply.  I'll be checking your references out....

Doug

On Mon, Mar 7, 2011 at 10:45 AM, Shamil Salakhetdinov
<shamil at smsconsulting.spb.ru> wrote:
> 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
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>