| | |
| | | $"AND c.TABLE_NAME = kcu.TABLE_NAME " + |
| | | $"AND c.COLUMN_NAME = kcu.COLUMN_NAME " + |
| | | $"AND kcu.CONSTRAINT_NAME = 'PRIMARY' " + |
| | | $"WHERE c.TABLE_NAME = '{tableName}'"; |
| | | $"WHERE c.TABLE_NAME = '{tableName}'"+ |
| | | $"ORDER BY c.ORDINAL_POSITION"; |
| | | |
| | | |
| | | List<ColumnModel> columnList = new List<ColumnModel>(); |
| | |
| | | model.Description = dt.Rows[n]["Description"].ToString(); |
| | | if (dt.Rows[n]["IsNullable"].ToString() != "") |
| | | { |
| | | if ((dt.Rows[n]["IsNullable"].ToString() == "1") || (dt.Rows[n]["IsNullable"].ToString().ToLower() == "true")) |
| | | if ((dt.Rows[n]["IsNullable"].ToString() == "1") || (dt.Rows[n]["IsNullable"].ToString().ToLower() == "true") || (dt.Rows[n]["IsNullable"].ToString().ToLower() == "yes")) |
| | | { |
| | | model.IsNullable = true; |
| | | } |