Suppose I have a string 'nvarchar(50)', which is for example the T-SQL string segment used in creating a table of that type. How do I best convert that to an enum representation of System.Data.DbType?
Could it handle the many different possible ways of writing the type in T-SQL, such as:
[nvarchar](50)
nvarchar 50
@Jorge Table: Yes, that's handy, but isn't there a prebaked converter? Otherwise good answer.
Thanks in advance