Subsonic 3.0 creates a byte array for a tinyint sql column

subsonic3

I was trying to use Subsonic to generate my DAL, but I noticed a bug while generating Classes using LinqToEntities T4 templates.
I noticed that one of the columns in a table was having the type tinyint, while generating a Property for this column it created one which returns a byte[] instead of a byte.

Also another Table had a Column named ModifiedBy with the type set to smallint. Subsonic created the Property in the class correctly as short however in one of the PropertyChanged methods it was expecting a string for this field and was setting its value to Environment.UserName.

Has anyone faced this issue before?
TIA..

Best Answer

you may have solved this by now but..

Search in the file SQLServer.ttinclude for "tinyint"
You'll see a C# switch statement
Modify the one for tinyint to something more useful, such as Integer

Worked for me

Related Solutions

SQL Views in SubSonic 3.0

To include views in your project

simply open SQLServer.ttinclude Find the query that load the tables ( search form 'const string TABLE_SQL') then change it to

const string TABLE_SQL=@"SELECT *
    FROM  INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE='BASE TABLE' 
    union
    select Table_catalog, table_schema, table_name, 'View' table_type 
    from information_schema.views";

if you are using it in an asp.net project you can exclude the aspnet table and views like so

const string TABLE_SQL=@"SELECT *
    FROM  INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE='BASE TABLE' 
        and table_name not like '%aspnet_%'
    union
    select Table_catalog, table_schema, table_name, 'View' table_type 
    from information_schema.views
    where table_name not like '%aspnet_%'";

Subsonic 3.0 and SqlHierachyID

Sprocs can be strongly-typed by calling ExecuteTypedList()

I would create an issue on the Github tracker to either add support for the type (someone will have to contribute this since I don't think it's a high priority) or to gracefully handle it when they exist.

Best Answer

Related Solutions

SQL Views in SubSonic 3.0

Subsonic 3.0 and SqlHierachyID

Related Topic