insert using objectdatasource with duplicacy check

Insert using objectdatasource with duplicacy check update#

Note: The included Northwind SQL Express database has been modified slightly to add a TimeStamp field into the Customer and Orders tables and contains several custom stored procedures (sprocs aren't required unless using that portion of the application). Databinding on the presentation layer is mainly done using the ObjectDataSource control.Īll of the queries performed in the application go against an object model created using the Visual Studio 2008 LINQ to SQL Designer.

Insert using objectdatasource with duplicacy check update#

It also demonstrates how the new ListView control can be used to display data, perform insert, update and delete operations and nest other controls such as the GridView. The application provides a presentation layer, business layer, data layer and model layer through separate projects as shown next: In a previous post comparing different LINQ options I mentioned that I'd be posting the code download as soon as it was ready. The application is for a talk I'll be giving at DevConnections in April discussing how LINQ technologies can be used in an N-Layer architecture. I've been spending some time lately working on a little sample application that demonstrates how an N-Layer ASP.NET 3.5 application can be built using LINQ, lambdas and LINQ with stored procedures. NET 3.5 has a lot of great new features that can significantly enhance developer productivity. Update: I refactored some of the code and also did a better job ensuring Dispose() is called everywhere so that the DataContext object gets cleaned up properly. NET Architecture ASP.NET ASP.NET AJAX C# Lambdas LINQ