LINQ to SQL - DLINQ
Hiding LINQ To SQL ADO.NET behind a simple class...
Using LINQ To SQL for ADO.NET...
Quick tip on LINQ To SQL.
Since we have two hours in Ft. Myers on Tuesday, I thought rather than talking 2 hours on Enterprise Library and Unity I can present both my South Florida Code Camp Presentations which are 1 hour in length. This will give us a lot more variety during the evening as we will be talking about Enterprise Library, Unity, and LINQ To SQL!
Examples of performance tuning those LINQ To SQL queries...
First book I have read that attempts to combine Domain-Driven Design Concepts with LINQ To SQL.
I think ASP.NET Dynamic Data Rocks for forms over data web applications. We have new updates for the runtime, templates, and MVC preview.
LINQ in Action provides some excellent coverage of the new language enhancements added for LINQ as well as the various flavors of LINQ.
Looks like the ASP.NET Dynamic Data Wizard will continue to be only found on MSDN Code Gallery as there is a new refresh available for Visual Studio 2008 SP1. Here is what it looks like in Visual Studio 2008 SP1 Beta.
The Visual LINQ Query Builder is a Visual Studio 2008 Add-In and designer that helps you create LINQ to SQL Queries in your application.
For kicks I thought I would create a rough Custom Profile Provider using LINQ To SQL since I was creating a custom profile provider for an application today anyway ( not using LINQ To SQL ). In the end, I think using LINQ To SQL is overkill for a custom profile provider that would be better served with a couple of stored procedures if using a database. It did make for some interesting playing. Read more...
In the last LINQ To SQL Post, I could have easily changed the EmployeeType Property on the Employee Entity from int to an enum, called EmployeeType, and apparently LINQ To SQL will automatically take care of the conversion from int to the enum for me. Read more...
With LINQ To SQL you can specify a Discriminator Column and Inheritance Mapping that specifies the type to be created in a hierarchy. Let's say we have an abstract Employee Class that maps to an Employees Table in the database with employees being an hourly employee, salaried employee, or commissioned-based employee. Read more...
This post is not a knock against the LINQ To SQL Debugger Visualizer in Visual Studio 2008, but rather a cautionary note in that the LINQ To SQL Debugger Visualizer is not a complete look at the SQL that will be generated by the DataContext Object. Read more...
In the last post I discussed creating stored procedures to help select data from the database using LINQ To SQL. In this post I want to briefly describe how to specify Insert, Update, and Delete Stored Procedures in LINQ To SQL to override the dynamic SQL used by the O/R Mapper.
Up until now we have been investigating how LINQ To SQL generates queries and how to tweak the model for more optimal performance. In this quick post, I want to talk about using stored procedures to get the data as opposed to letting LINQ To SQL generate the dynamic SQL in your data access layer.
This is another post in a series of posts on LINQ To SQL in how I think I have discovered a potential performance problem of LINQ To SQL only to find an elegant solution to the problem using LINQ To SQL. Sweet. Read more...
I talked about how LINQ to SQL will prefetch or lazy load relationships via a LinqDataSource based on setting the LoadOptions on the DataContext. It is interesting how LINQ to SQL minimizes roundtrips but duplicates data in the resultset in this case of fetching a Blog and its associated Categories. Read more...
Use DataLoadOptions with the LinqDataSource to specify the prefetch and lazy-loading options of the DataContext to greatly increase the performance of the queries using LINQ to SQL. Read more...
If you are into code generation, it appears a new version of CodeSmith is out - version 4.1. I haven't downloaded it yet, but two bulleted features make me pretty excited: Visual Studio 2008 Support and LINQ to SQL Templates. Read more...
LINQ to SQL in Orcas Beta 2 has a number of new features that help with common validation scenarios both at the property level and at the business object level. Enteprise Library's Validation Application Block Can Help.
The new LinqDataSource Control in Orcas Beta 2 provides some wonderful rapid application development for you ASP.NET websites when using LINQ to SQL. Read more...
In Orcas Beta 2 we will see partial methods, which provides a hook for developers to “inject” code into partial classes without running the risk of that code being overwritten when the class is being generated in the future. Read more...
I had a chance to play with Linq to SQL this evening in the Visual Studio ORCAS March 2007 CTP.The visual designer for Linq to SQL makes things a snap, allowing you to drag SQL Server Database Tables from the Server Explorer to the designer surface. Linq to SQL creates all the classes, relationships, etc. for you as soon as you drop each table onto the surface. Here is a quick Linq to SQL Tutorial I whipped together in about 5 minutes...
|