-
-
Save shane-powell/cffcc6de1f38ecc09b4d7d5cf5c33a48 to your computer and use it in GitHub Desktop.
Generate C# class from database table (Implementing INotifyPropertyChanged)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Forked from SO: http://stackoverflow.com/questions/5873170/generate-class-from-database-table | |
declare @TableName sysname = 'TableNameHere' | |
declare @Result varchar(max) = 'using System; | |
using System.ComponentModel; | |
using System.Runtime.CompilerServices; | |
public class ' + @TableName + ' : INotifyPropertyChanged | |
{ | |
' | |
select @Result = @Result + ' | |
private ' + ColumnType + NullableSign + ' ' + Lower(LEFT(ColumnName,1))+SUBSTRING(ColumnName,2,LEN(ColumnName)) + '; | |
' | |
from | |
( | |
select | |
replace(col.name, ' ', '_') ColumnName, | |
column_id ColumnId, | |
case typ.name | |
when 'bigint' then 'long' | |
when 'binary' then 'byte[]' | |
when 'bit' then 'bool' | |
when 'char' then 'string' | |
when 'date' then 'DateTime' | |
when 'datetime' then 'DateTime' | |
when 'datetime2' then 'DateTime' | |
when 'datetimeoffset' then 'DateTimeOffset' | |
when 'decimal' then 'decimal' | |
when 'float' then 'float' | |
when 'image' then 'byte[]' | |
when 'int' then 'int' | |
when 'money' then 'decimal' | |
when 'nchar' then 'char' | |
when 'ntext' then 'string' | |
when 'numeric' then 'decimal' | |
when 'nvarchar' then 'string' | |
when 'real' then 'double' | |
when 'smalldatetime' then 'DateTime' | |
when 'smallint' then 'short' | |
when 'smallmoney' then 'decimal' | |
when 'text' then 'string' | |
when 'time' then 'TimeSpan' | |
when 'timestamp' then 'DateTime' | |
when 'tinyint' then 'byte' | |
when 'uniqueidentifier' then 'Guid' | |
when 'varbinary' then 'byte[]' | |
when 'varchar' then 'string' | |
else 'UNKNOWN_' + typ.name | |
end ColumnType, | |
case | |
when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') | |
then '?' | |
else '' | |
end NullableSign | |
from sys.columns col | |
join sys.types typ on | |
col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id | |
where object_id = object_id(@TableName) | |
) t | |
order by ColumnId | |
set @Result = @Result + ' | |
/// <summary> | |
/// Handles a property changing. | |
/// </summary> | |
public event PropertyChangedEventHandler PropertyChanged; | |
' | |
select @Result = @Result + ' | |
public ' + ColumnType + NullableSign + ' ' + Upper(LEFT(ColumnName,1))+SUBSTRING(ColumnName,2,LEN(ColumnName)) + ' | |
{ | |
get | |
{ | |
return this.' + Lower(LEFT(ColumnName,1))+SUBSTRING(ColumnName,2,LEN(ColumnName)) + '; | |
} | |
set | |
{ | |
this.' + Lower(LEFT(ColumnName,1))+SUBSTRING(ColumnName,2,LEN(ColumnName)) + ' = value; | |
this.OnPropertyChanged(); | |
} | |
} | |
' | |
from | |
( | |
select | |
replace(col.name, ' ', '_') ColumnName, | |
column_id ColumnId, | |
case typ.name | |
when 'bigint' then 'long' | |
when 'binary' then 'byte[]' | |
when 'bit' then 'bool' | |
when 'char' then 'string' | |
when 'date' then 'DateTime' | |
when 'datetime' then 'DateTime' | |
when 'datetime2' then 'DateTime' | |
when 'datetimeoffset' then 'DateTimeOffset' | |
when 'decimal' then 'decimal' | |
when 'float' then 'float' | |
when 'image' then 'byte[]' | |
when 'int' then 'int' | |
when 'money' then 'decimal' | |
when 'nchar' then 'char' | |
when 'ntext' then 'string' | |
when 'numeric' then 'decimal' | |
when 'nvarchar' then 'string' | |
when 'real' then 'double' | |
when 'smalldatetime' then 'DateTime' | |
when 'smallint' then 'short' | |
when 'smallmoney' then 'decimal' | |
when 'text' then 'string' | |
when 'time' then 'TimeSpan' | |
when 'timestamp' then 'DateTime' | |
when 'tinyint' then 'byte' | |
when 'uniqueidentifier' then 'Guid' | |
when 'varbinary' then 'byte[]' | |
when 'varchar' then 'string' | |
else 'UNKNOWN_' + typ.name | |
end ColumnType, | |
case | |
when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') | |
then '?' | |
else '' | |
end NullableSign | |
from sys.columns col | |
join sys.types typ on | |
col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id | |
where object_id = object_id(@TableName) | |
) t | |
order by ColumnId | |
set @Result = @Result + ' | |
/// <summary> | |
/// Called when [property changed]. | |
/// </summary> | |
/// <param name="propertyName">Name of the property.</param> | |
public void OnPropertyChanged([CallerMemberName]string propertyName = "") | |
{ | |
this.PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName)); | |
} | |
}' | |
print @Result |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment