I am trying out SubSonic to see if it is viable to use on production projects. I seem to have stumbled upon an issue whith regards to updating the database with default values (String and DateTime) when a new column is created.

If a new property of DateTime or String is added to an object.

public class Bug
{
    public int BugId { get; set; }
    public string Title { get; set; }
    public string Overview { get; set; }
    public DateTime TrackedDate { get; set; }
    public DateTime RemovedDate { get; set; }
}

When the code to add that type of object to the database is run

var repository = new SimpleRepository(SimpleRepositoryOptions.RunMigrations);           

repository.Add(new Bug()
{
    Title = "A Bug",
    Overview = "An Overview",
    TrackedDate = DateTime.Now
});

it creates the following sql:

UPDATE Bugs SET RemovedDate=''01/01/1900 00:00:00''

For some reason it is adding double 2 single quotes to each end of the string or DateTime.

This is causing the following error:

System.Data.SqlClient.SqlException - Incorrect syntax near '01'

I am connecting to SQL Server 2005

Any help would be appreicated as apart from this issue i am finding SubSonic to be a great product.

I have created a screen cast of my error here: