Where to put extra functionality for the database layer (Linq-to-SQL)

Question

What would be the best method to implement extra functionality in a database layer that uses Linq-to-SQL? Currently I'm looking at implementing functions for adding information based on presets and similar tasks?

Inserts, updates and deletes requires access to the DataContext and in the Table classes you don't have access to the context. I've seen solutions that uses Singletons but it seems like a hack and I wonder if anyone else has run into this problem and what your solutions were? Is there a better way all together to implement similar functionality.

The reason for me looking to add this functionality to the database layer is that I have several applications that all use the same database objects and I want to be able to use these functions from all applications so I don't have to rewrite a lot of code.

That's not quite what I meant. I want to be able to do complex actions like updating one table and adding a record to another table based on information from the first one.

Say I have selected a Customer record and I want to update this with information, and when this happens I want it to add another record to the "Updates" table to keep track of when updates happened and who did them. This is only an example of course. Things needed to be done can be more complex.

Basically I want to add a method to a table object to perform modifications to a specific row in that table and then do inserts and updates on other objects. I know that you can use partial classes and I do that extensively already.

Example:

db.Customers.Where(c => c.CustomerID == 5).AddOrder(orderDetails);

I feel that I can't really put my problem into words to make it understandable :)

Thomas Eyde · Accepted Answer · 2008-10-25 22:48:42Z

1

Entity classes in Linq to SQL are partial. You could extend them with the rules you need.

Or you could build your own business entities from the Linq to SQL entities. Your business entities would then contain the rules on when to do what.

answered Oct 25, 2008 at 22:48

Thomas Eyde

3,9943 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dougajmcdonald · Accepted Answer · 2011-08-31 07:29:16Z

1

If you're purely after adding some wrapper functionality around linq or any class generally, could you not use the Extension method approach in C# 3 and above by using static helper methods along these lines:

public static class StringExtensions 
{
    public static int ToInt(this string oString)
    {
        return int.Parse(oString);
    }
}

That way you could have a static helper class offering helper functionality specific to particular classes which you can port about between projects or possibly chuck into a seperate DLL and just import where needed?

answered Aug 31, 2011 at 7:29

dougajmcdonald

20.2k12 gold badges61 silver badges100 bronze badges

Comments

user1228 · Accepted Answer · 2008-10-10 17:23:14Z

0

I hate to say it, but what about stored procedures?

On my project, whatever extra functionality we want to provide we stick in a partial class. The data context class is marked partial, so you can add methods to the context without worrying about re-generating the context nuking your work.

answered Oct 10, 2008 at 17:23

user1228

Comments

BenMorel · Accepted Answer · 2014-01-05 16:34:53Z

0

You can use generic data context extensions for common data access methods like insert,delete etc as described in http://weblogs.asp.net/stephenwalther/archive/2008/08/26/asp-net-mvc-tip-38-simplify-linq-to-sql-with-extension-methods.aspx. and partial classes for less common functionality as Will suggested.

edited Jan 5, 2014 at 16:34

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Oct 10, 2008 at 21:28

aogan

2,2811 gold badge15 silver badges24 bronze badges

Collectives™ on Stack Overflow

Where to put extra functionality for the database layer (Linq-to-SQL)

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related