Earlier I displayed a neat trick to keep track of modification and creation data with ADO.NET entity framework for .NET Framework 4. I quickly discovered there’s a new feature in .NET 4 to simplify things even more. Visual Studio 2010 enables the use of T4 templates to customize the logic used...
This one I had lying around for quite a while now, but I still think it’s a nice trick when you are working with ADO.NET entity framework inside your application. In a lot of applications there’s some way to track who created and/or modified entities inside the application. In this article...
SQL server 2008 has a new feature called table-valued parameters. A great feature I tell you, because it allows developers to supply a table of values to a stored procedure for processing. One practical scenario for this is having an insert procedure that allows multiple inserts to be submitted at once...
Currently I'm hard at work on a project where we use Linq to SQL quite a lot. It has led to some interesting patterns and anti-patterns which I want to share in this article. The idea is to show some principals that me and others on the team have encountered and what you can do to prevent the same...
Microsoft released the ADO.NET entity framework with their latest service pack and I’m quite happy with what they have done so far. The entity framework helps reduce code complexity for creating entities and it also saves you the work of having to write all the mapping code yourself. One of the...
Roy (A colleague) sparked me with some new inspiration to try something new. He wrote an article on ADO.NET data service which made me excited to try this one out. I didn't think much of it first, but I'm eager to try it out and see how it holds up with a more elaborate application. The first experience...
Introduction One of the things that happens a lot in databases but less in object oriented software is normalization. In databases we often split one logical entity into multiple entities to remove redundant data. However in our client that uses this data it's often the other way around. Looking at ADO...
Introduction At Info Support we work with stored procedures in SQL 2000/2005 to access our data, this has a couple of advantages, like decoupling the interface from the actual table structure, reduce the number of errors in queries, etc. As you can imagine, I want this good practice to continue even...
Manuel notified me of the possibility to use the ADO.NET framework instead of my own custom solution for the data access layer of my opensource scheduling application. I must say I was a bit skeptical because I had tried it before and it didn't impress me back then. But things can change, so I installed...