Programmatically mapping .NET types onto SQL Server types?

Question

Is there any way to programmatically map a .NET type (such as typeof(int)) into its corresponding SqlDbType (such as SqlDbType.Int)?

Some more context might help. ASP takes care of this for you in most cases (eg when you create parameters.) What exactly do you want to do? — Hogan
– Hogan, Commented Mar 11, 2011 at 16:43
I want to write two classes that handle the execution of DbCommands and the creation of its DbParameters respectively, hiding the database-specific details from the rest of the application. And also, I don't want to map types manually; at least, not for the case of Sql Server. — isekaijin
– isekaijin, Commented Mar 11, 2011 at 16:47

skaz · Accepted Answer · 2011-03-11 16:45:23Z

5

Have you looked into The Entity Framework? This will do all of the mappings for you.

answered Mar 11, 2011 at 16:45

skaz

22.7k20 gold badges73 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Frank Hale Over a year ago

+1 - I was also thinking the same thing or perhaps LINQ to SQL or another ORM.

isekaijin Over a year ago

Excuse my ignorance. Do the Entity Framework or LINQ to SQL support stored procedures?

Harsh Baid Over a year ago

ya it does support stored procedures also

Hogan Over a year ago

It does support SPs but from my experience it is a bit like putting a tutu on a pig.

TomTom · Accepted Answer · 2011-03-11 16:44:41Z

2

Not that I know of, tehre is no exposure of whatever method is used internally. Your best bet it your own extension method / mapping repository that uses a switch statement or a hashtable.

answered Mar 11, 2011 at 16:44

TomTom

62.4k11 gold badges95 silver badges152 bronze badges

Comments

Mikhail · Accepted Answer · 2011-03-13 18:27:45Z

1

See Also:

SQL Server Data Type Mappings (ADO.NET)

answered Mar 13, 2011 at 18:27

Mikhail

9,3104 gold badges35 silver badges52 bronze badges

1 Comment

isekaijin Over a year ago

I wanted a function that performed those mappings, instead of me having to manually implement them. Thanks, anyway.

Collectives™ on Stack Overflow

Programmatically mapping .NET types onto SQL Server types?

3 Answers 3

4 Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Related