How about something like this: public T DeadlockRetryHelper<T>(Func<T> repositoryMethod, int maxRetries) { int retryCount = 0; while (retryCount < maxRetries) { try { return repositoryMethod(); } catch (SqlException e) // This example is for SQL Server, change the exception type/logic if you’re using another DBMS { if (e.Number == 1205) // SQL Server error code … Read more
Actually the T4 templates in EF 4.0 were designed with this scenario in mind 🙂 There are 2 templates: One for the Entities themselves (i.e. ModelName.tt) One for the ObjectContext (i.e. ModelName.Context.tt) You should put the ModelName.tt file in you POCO project, and just change the template to point to the EDMX file in the … Read more
Out of my head: I define two example domains, User and Animal, an base storage class Store and two specialized Storage classes UserStore and AnimalStore. Use of context manager closes db connection (for simplicity I use sqlite in this example): import sqlite3 def get_connection(): return sqlite3.connect(‘test.sqlite’) class StoreException(Exception): def __init__(self, message, *errors): Exception.__init__(self, message) self.errors … Read more
The thing is this, LINQ to SQL is not a true Object Relation Mapper (ORM), it is a data access layer generator. You can make it be an ORM by going deep by hand editing XML files and playing with SqlMetal and whatnot, but where it shines is as a DAL. The idea behind an … Read more
It depends on how closely-related these projects are. Ask yourself the following questions: Will they always need to be branched/tagged together? Will you want to commit over all projects, or does a commit mostly only touch one project? Does the build system operate on all of them or do they have a boundary there? If … Read more
Found the answer here by “adding additional level of indirection” we get: public virtual void SetModified(object entity) { Entry(entity).State = EntityState.Modified; } and use DbContext.SetModified(entity) in our controller. mockContext.Setup(c => c.SetModified(It.IsAny()));
First, there is no set of rules that’s going to work in every situation. How you model you’re application depends a lot on the type and complexity of the project. Having said that, here are some ideas: Nothing wrong with calling the repository from a controller. Just make sure the controller does not contain business … Read more
Hey the only way of which I think now is to add an status parameter and use the operation findAndModify(), which enables you to atomically modify a document. It’s a bit slower, but should do the trick. So let’s say you add an status attribut and when you retrieve the document change the status from … Read more
I think the term “repository” is commonly thought of in the way the “repository pattern” is described by the book Patterns of Enterprise Application Architecture by Martin Fowler. A Repository mediates between the domain and data mapping layers, acting like an in-memory domain object collection. Client objects construct query specifications declaratively and submit them to … Read more
Suppose your application manages Person objects, with each instance having name, age and jobTitle properties. You would like to persist such objects, retrieve them from the persistence medium and maybe update (say, on their birthday, increment the age) or delete. These tasks are usually referred to as CRUD, from Create, Read, Update and Delete. It … Read more