public IEnumerable <dynamic> GetTableColumnes(string tableName) { DynamicParameters Parameters = new DynamicParameters(); Parameters.Add("TableName", tableName); var sql = "SELECT SYSCOLUMNS.name as code,SYSCOLUMNS.xtype as dataType,SYSCOLUMNS.length as maxLength,SYSCOLUMNS.isnullable as isRequired FROM SYSCOLUMNS WHERE ID=OBJECT_ID(@TableName)"; //var sql = "SELECT SYSCOLUMNS.name as code,sysTypes.name as dataType,SYSCOLUMNS.length as maxLength,SYSCOLUMNS.isnullable as isRequired FROM SYSCOLUMNS left join sysTypes on SYSCOLUMNS.xtype=sysTypes.xtype WHERE ID=OBJECT_ID(@TableName)"; var ret = _dynamicRepository.Query(sql, Parameters); return(ret); }