CODEWITHSUNDEEP
c#data-access-layer
Jeremy Thomson
Jeremy Thomson

Reputation: 999

System.Data.DbType Vs System.Data.SqlType

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);

Upvotes: 0

Views: 782

Answers (2)

Gregory A Beamer
Gregory A Beamer

Reputation: 17010

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.

Upvotes: 3

Mitch Wheat
Mitch Wheat

Reputation: 300769

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

Upvotes: 1

Related Questions