Subsonic 2.2 Generated Property for SQL Server 2008 Date

Im using latest SVN 2.2 build compiled with VS 2008. When I build my VB classes using Sonic.exe any columns of type Date (Not Datetime) are generated as "System.String". Has anybody else found this problem and have a solution or is this a problem with Subsonic?

Answers


Submit an issue here: http://code.google.com/p/subsonicproject/issues/list


It's still a pending issue, but it's an easy fix. If you have the SubSonic source code, make a few edits.

-- src\SubSonic\DataProviders\SqlDataProvider.cs. Around line #1010 above "case datetime" add:

            case "date":
                return DbType.Date;

-- src\SubSonic\ActiveRecord\AbsractList.cs Around line #85 above "else if (dbType == DbType.DateTime)" add:

        else if (dbType == DbType.Date)
        {
            DateTime dX = Convert.ToDateTime(xVal);
            DateTime dY = Convert.ToDateTime(yVal);
            result = dX.CompareTo(dY);
        }

-- src\SubSonic\CodeLanguage\CSharpCodeLanguage.cs Around line #222 above "case DbType.DateTime" add:

            case DbType.Date:

I'm 99% these were the main changes needed, without these changes the last release will not properly support the SQL Server 2008 "DATE" data type.


Need Your Help

RabbitMQ Fanout Exchange (VirtualTopic Equivalent)

jms rabbitmq activemq

I'm looking at swapping out ActiveMQ with RabbitMQ for a few reasons. I currently have multiple services which are each capable of publishing events (and they publish those events to a specific

Json - Mysql Charset Problem

php mysql json utf-8

I convert my php array to json using json_encode, Than I record this json data to my database .While json_encode encodes my data , It also converts strings to utf8 , this changes special characters...