SubSonic with MS SQL 2008?

Question

I have been using subsonic with MS SQL 2005 for about a year now. For those of you who have moved to SQL 2008, is subsonic compatiable with that? Have you had too many issues with SubSonic with SQL 2008? Just trying to get a feel if I should upgrade to SQL 2008 at this time or not.

Thanks

Answer 1

I've not used SQL2008 myself, but I know there is still a bug in SubSonic 2.1 and 2.2 in handling the new date only and time only data types (it sees them as strings).

Answer 2

SubSonic works great with Sql Server 2008. If you are at all worried you can download the source and add a reference to the project so that you can fix any errors that come up.

If you download 2.2(which should have been named 2.1.1 as it is a minor bug fix release) you will notice that the Sql Server 2008 provider inherets from the 2005 provider and I believe that it only overrides one function meaning that there is very little that differs between them though you could always fix anything you need to fix if you ever run into a bug(I haven't run into anything in my development and I use SQL Server 2008)