Channel 9 Interview - John Stallo on Building N-Tier Applications in VS 2008

Comments

# Kiran said on September 11, 2007 5:29 PM:

This is great & John Stallo explains this really well.  What would even be greater is showing how LINQ fits into this

# bill burrows said on September 12, 2007 5:23 PM:

This was really useful content. Also, the format you are using with the video/screnn recording are so much nicer than just the screen recording -- it's nice to be able to see the presenter.

Great job.

# Beth Massi said on September 13, 2007 1:35 PM:

Hi Kiran,

The beauty of LINQ is that you can use it in any layer of your application architecture because it's a querying technology that not only works over databases but also in-memory objects (any .NET collection) as well as XML. You can even query over typed datasets. For instance in the example John gave us we could have started writing LINQ queries over the client-side datasets in order to aggregate the order details and display totals to the user.

Watch the LINQ videos to help you get started: http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx#linq

Cheers,

-B

# John said on September 21, 2007 1:12 PM:

Thanks for the video...it was useful.  I'm curious to know your opinion whether the way we have a n-tier architecture in VS2005 (e.g. Data Table, Table Adapters, DataAccess Layer, Bussiness Object Layer) and the coding behind that, will be vastly different with VS 2008?  I understand from the video that the there will be a different physcial file for storing some of the data set information w/ vs2008, but in general will the two versions be different?

# Beth Massi said on September 21, 2007 2:09 PM:

Hi John,

The code that gets generated for VS2008 DataSets is different (adds features like the TableAdapterManager for hierarchical updates and also supports LINQ querying) but it is backwards compatible with the way you work with them in VS2005 so you should be able to take advantage of the new version without breaking your code.

There are new ways of accessing your data however, if you do choose to change your architecture. The LINQ to SQL classes and the O/R designer can be used in place of the DataSet but the DataSet is not going away.

Cheers,

-B

# jimrand@ix.netcom.com said on October 3, 2007 12:45 PM:

Great video.  Question: has the sql designer for data/table adapters been cleaned up.  In the current VS 2005 version, it is unusable for handling updates and inserts for autoincrement keys and timestamps. Also, the designer chocks when selecting grandchildren of a grandparent.  I finally had to build my own code generation tools for configuring data adapters.

Designer chocking SQL examples:

SELECT AccessFlagLookupID, AccessFlag, Description, LastUpdated, LastUpdatedBy, CAST(TS AS INT) AS TS FROM AgencyNET.AccessFlagLookup

INSERT INTO [AgencyNET].[AccessFlagLookup] ([AccessFlag], [Description], [LastUpdatedBy]) VALUES (@AccessFlag, @Description, @LastUpdatedBy);SELECT AccessFlagLookupID, CAST(TS AS INT) AS TS FROM AgencyNET.AccessFlagLookup WHERE (AccessFlagLookupID = SCOPE_IDENTITY())

UPDATE [AgencyNET].[AccessFlagLookup] SET [AccessFlag] = @AccessFlag, [Description] = @Description, [LastUpdated] = getutcdate(), [LastUpdatedBy] = @LastUpdatedBy WHERE (([AccessFlagLookupID] = @Original_AccessFlagLookupID) AND (CAST(TS AS INT) = @Original_TS));SELECT CAST(TS AS INT) AS TS FROM AgencyNET.AccessFlagLookup WHERE (AccessFlagLookupID = @AccessFlagLookupID)

DELETE FROM [AgencyNET].[AccessFlagLookup] WHERE (([AccessFlagLookupID] = @Original_AccessFlagLookupID) AND (CAST(TS AS INT) = @Original_TS))

SELECT V.EndUserFramingVendorEEID, V.EndUserFramingSolutionUrlID, V.VendorEmployeeID, V.LastUpdated, V.LastUpdatedBy, CAST(V.TS AS INT) AS TS

FROM AgencyNET.EndUserFramingVendorEE AS V INNER JOIN

    AgencyNET.EndUserFramingSolutionUrl AS F ON V.EndUserFramingSolutionUrlID = F.EndUserFramingSolutionUrlID INNER JOIN

    AgencyNET.EndUserWebSite AS W ON F.EndUserWebSiteID = W.EndUserWebSiteID

WHERE W.EndUserID = @EndUserID

# Dudleigh said on October 3, 2007 2:20 PM:

C# Version for anyone thats interested

Leave a Comment

Name (required) 

Your URL (optional)

Comments (required) 

Remember Me?

About Beth Massi