Archives

Archives / 2008
  • Enum in ADO.NET Entity Framework v1

    There is no direct support for enum type in ado.net entity framework v1. But it is rather easy to solve this problem.

    All u need to do is to create int property with private getter and setter and then add public property to your partial class, which type is enum:

  • Backup and SQL Server diagram opennig problem.

    Very often people who works with SQL Server database get the following error when they trying to open database diagrams after restoring database from back up:

    Database diagram support objects cannot be installed because this database
    does not have a valid owner. To continue, first use the Files page of the
    Database Properties dialog box or the ALTER AUTHORIZATION statement to set
    the database owner to a valid login, then add the database diagram support
    objects.

    To fix this problem you should execute this T-SQL script:

    EXEC sp_dbcmptlevel 'yourDB', '90';
    go
    ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
    go
    use [yourDB]
    go
    EXECUTE AS USER = N'dbo' REVERT
    go

  • Simple database fixture.

    Very often we need to write tests which interact with the database. I found that many people are still doing complex clean up manipulation in tear down method. But in most cases it is useless work. All you need to  perform clean up of database after each test is to use TransactionScope. This process is so simple that it is hard to believe that it works. The main idea is to create TransactionScope object in SetUp mehod (Constructor in xUnit) and dispose it in TearDown method (Dispose in xUnit).