Created
July 28, 2017 08:01
-
-
Save mahmut-gundogdu/589db15c64262b00bbba7f62c11d331d to your computer and use it in GitHub Desktop.
sql server table class yapan kodumuz: Kaynak: https://stackoverflow.com/questions/5873170/generate-class-from-database-table
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
create function ProperCase(@Text as varchar(8000)) | |
returns varchar(8000) | |
as | |
begin | |
declare @Reset bit; | |
declare @Ret varchar(8000); | |
declare @i int; | |
declare @c char(1); | |
select @Reset = 1, @i=1, @Ret = ''; | |
while (@i <= len(@Text)) | |
select @c= substring(@Text,@i,1), | |
@Ret = @Ret + case when @Reset=1 then UPPER(@c COLLATE Latin1_General_CS_AS) else LOWER(@c) end, | |
@Reset = case when @c like '[a-zA-Z]' then 0 else 1 end, | |
@i = @i +1 | |
return REPLACE(@Ret,'_','') | |
end | |
GO | |
declare @TableName sysname = 'companies' | |
declare @Result varchar(max) = 'public class ' + dbo.ProperCase(@TableName) + ' | |
{' | |
select @Result = @Result + ' | |
[Column("'+ColumnName+'",TypeName="'+ColumnTypeSql+'")] | |
public ' + ColumnType + NullableSign + ' ' + dbo.ProperCase(ColumnName) + ' { get; set; } | |
' | |
from | |
( | |
select | |
replace(col.name, ' ', '_') ColumnName, | |
column_id ColumnId, | |
typ.name ColumnTypeSql, | |
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 'string' | |
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 + ' | |
}' | |
print @Result | |
GO | |
drop function ProperCase |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment