If you’ve looked through the web.config or the machine.config then you’ve had to have seen various type strings strewn about the configuration. But have you ever wondered how they use those type strings to actually make a useful class instance (or object instance if you prefer) out of that type string? It’s actually really easy.<\/p>\n
You only have to do two thing. First, pass the type string to the Type.GetType<\/strong> method. If you pass in a valid type string, the method will return type information for that type. If you pass in an invalid type string, the method returns null (though you can send in a boolean parameter to tell it to throw an error right there if you want). <\/p>\n Second, pass the resulting type information into the Activator.CreateInstance<\/strong> method. There are 13 overloads to the CreateInstance method, so you can also pass in constructor parameters (if needed) as well as a bunch of other information I’ve never really bothered to research.<\/p>\n Following is an example that shows how to create different database connection objects using type strings:<\/p>\n<\/p>\n \/\/Use must use an interface (or base class) to store a Type cnxType; \/\/stores reference to the object type \/\/Example of creating a SqlConnection using a type string cnx = (IDbConnection)Activator.CreateInstance(cnxType); <\/p>\n \/\/Example of creating an OleDbConnection using a type string cnx = (IDbConnection)Activator.CreateInstance(cnxType); <\/p>\n \/\/ … Do Something With Your Connection …<\/p>\n","protected":false},"excerpt":{"rendered":" If you’ve looked through the web.config or the machine.config then you’ve had to have seen various type strings strewn about the configuration. But have you ever wondered how they use those type strings to actually make a useful class instance (or object instance if you prefer) out of that type string? It’s actually really easy….…<\/p>\n","protected":false},"author":46738,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-2330","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/46738"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=2330"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2330\/revisions"}],"predecessor-version":[{"id":41405,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2330\/revisions\/41405"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=2330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=2330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=2330"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=2330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\/\/reference to the object you want to create because the
\/\/exact object type varies based on which type string
\/\/you use to create the object. In this example we are
\/\/creating either a SqlDbConnection or an
\/\/OleDbConnection, so we use an IDbConnection to store a
\/\/reference to the object because both implement the
\/\/IDbConnection interface.<\/p>\n
IDbConnection cnx; \/\/stores reference to the object instance<\/p>\n
cnxType = Type.GetType(@”System.Data.SqlClient.SqlConnection, System.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″); <\/p>\n
cnxType = Type.GetType(@”System.Data.OleDb.OleDbConnection, System.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″);<\/p>\n