with linq to sql dbml, how to get the size of a datatype? like varchar(50), how to get that 50?

Question

with linq to sql(dbml file), how to get the size of a datatype?

for an example, varchar(50), how to get that 50?

thanks

Answer 1

You could grab the string (ex: "NVarChar(30)") from the ColumnAttribute associated with the property.

var prop = typeof(User).GetProperty("FirstName");
var attr = (ColumnAttribute)prop.GetCustomAttributes(typeof(ColumnAttribute), false)[0];
string dbType = attr.DbType;
int index = dbType.IndexOf("(") + 1;
int width = int.Parse(dbType.Substring(index, dbType.IndexOf(")") - index));

Answer 2

You can also do it like this...

    String databaseType = 
        *DataContextInstance*.Mapping.MappingSource
        .GetModel(typeof(*DataContext*))
        .GetMetaType(typeof(*Entity*))
        .DataMembers.First(x => x.Name.Equals("ColumnName"))
        .DbType;

Hope that helps :)

Answer 3

I used that method