System.Data.DbType Vs System.Data.SqlType

Question

Am using enterprise library data access application block... is there any performance impact of using System.Data.DbType Vs System.Data.SqlType?

And also, would like to know performance impact for the statement: DatabaseFactory.CreateDatabase("MyDB")

Vs

new SqlDatabase(myConnectionString);

Thanks.

Answer 1

Any performance difference will be neglible (especially compared with database accesses).

Answer 2

The impact here is not one of performance but more explicitness versus flexibility. the DBType and DatabaseFactory methods are more flexible and allow you to flip the type of database you are using. You might see a small bit of perf in the other direction, but not enough to make your decision based on perf.