Generating data for tables in table per class inheritance tree using data generation plans
I am using Visual Studio database project and data generation plan to populate my database with random data. In my
Read more
Data platform
Using timer based Unit of Work and Command classes to measure repositories performance
In my last post Find out how long your method runs I introduced how to measure the speed of code using actions. In this posting I will make a step further and give you some ideas about how to create easily measurable code units and how to build measurable scenarios of them. As a foundation I use simplified versions of patterns like Command and Unit of Work.
Read more
Returning paged results from repositories using PagedResult
During my large database experiment I wrote simple solution for paged queries that I can use in my repositories. This far my experiments have shown pretty good results and I think it is time to share some of my code with you. In this posting I will show you how to create paged results using NHibernate and Entity Framework based repositories.
Read more
Copying data from one MSSQL database to another
I have database that has data imported from another server using import and export wizard of SQL Server Management Studio. There is also empty database with same tables but it also has primary keys, foreign keys and indexes. How to get data from first database to another? Here is the description of my crusade. And believe me – it is not nice one.
Read more
Entity Framework 4.0: Optimal and horrible SQL
Lately I had Entity Framework 4.0 session where I introduced new features of Entity Framework. During session I found out
Read more
Using NHibernate order-by attribute to sort names history
I am writing application that besides other cool things lets users insert information about business contacts. My system is able to keep names history of contacts. In this posting I will show you how to use NHibernate mappings to keep names ordered logically.
Read moreVisual Studio 2010: Database projects
Visual Studio 2008 introduced us database projects. These projects are also present in Visual Studio 2010. I noticed some differences already when building my photo gallery application. Let’s see how these projects work under Visual Studio 2010.
Read moreAttaching SQL Server database without log file
I needed to attach SQL Server 2008 database to server. There was no log file, just mdf. I don’t know why but it is not very easy to get this database online. After some digging in internet I found solution.
Read moreThe changes you have made require the following tables to be dropped and re-created
When changing tables in SQL Server Management Studio 2008 you may get the following error: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. I was surprised when I saw this message first but there is very simple solution.
Read moreYou must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column
One error you may get when querying SQL Server databases through MS Access is “You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column”. This error appears when you open recordset that contains IDENTITY column.
Read more