ILinqRepository at last

LINQ to SQL is a very easy to use and very powerful tool for many things when dealing with SQL.  But the time has come that I need to wrap it all up and use an iRepository pattern.  I’ve Googled for the IRepository and found a few useful references but none that will complete my […]

Read More

Transaction scoping within Linq to Sql

If you are like me and us are using an IRepository for Linq to SQL you’ll probably at some point need to be able to generate a Transaction. As the IRepository saves records as it goes and not on a SubmitChanges() we’re going to have to use the Microsoft TransactionScope Class, from the System.Transactions (in […]

Read More

How to generate LINQ to SQL Mapping

You may or may not have come across the ability within LINQ to SQL to have mapping to and from your own objects. Microsoft has a mapping builder called sqlmetal, which is a code generation tool to generate the mapping automatically. Here is a sample command line to generate the mapping file. [code language=c#] sqlmetal […]

Read More

LINQ to Entity Framework

What with Entity Framework around, I have been finding it quite hard to find any good information about the Framework, so I have started to compile a list of good resources The ADO.NET Entity Framework Overview Code Samples Mike Taulty is Mr Entity Framework Professional ADO.NET 3.5 with LINQ and the Entity Framework Entity Framework […]

Read More

LINQ to SQL v LINQ to Entities

Whatare the differences between LINQ to SQL v LINQ to Entities, well: LINQ to SQL uses tables as entities LINQ to Entities allows me to write C# LINQ queries that run against a conceptual data model. The following table provides a summary of the features within each LINQ object So this means that LINQ to SQL […]

Read More

Using LINQ to SQL

Found these great articles on LINQ to SQL, well worth reading as it the way to go forwards Using LINQ to SQL (Part 1) LINQ to SQL (Part 2 – Defining our Data Model Classes) LINQ to SQL (Part 3 – Querying our Database)

Read More