c# - Get connectionstring from Registry LINQtoSQL -
i confused how connectionstring stored in registry used datacontext.
where , how go this:
public dataclassesdatacontext() :              base(global::ddstime.properties.settings.default.ddstimeconnectionstring, mappingsource)     {         oncreated();     }   to not using properties.settings.default.ddstimeconnectionstring value registry?
i want way, because application used @ different locations, , not want leave connectionstring in config file see. little script, machines insert connectionstring key in registry, , there no need create different 'versions' each locations uses own sql server onsite.
if don't have suitable constructor, should easy create 1 :
public dataclassesdatacontext(string connectionstring) :          base(connectionstring, mappingsource) {     oncreated(); }   this means need pass connectionstring every time create new datacontext. if prefer, can change current constructor like
private static string getdefaultconnectionstring() {     var connectionstring = ... // read value registry     if (string.isnullorempty(connectionstring))         connectionstring = global::ddstime.properties.settings.default.ddstimeconnectionstring ;     return connectionstring; }  public dataclassesdatacontext() :             base(getdefaultconnectionstring(), mappingsource) {     oncreated(); }      
Comments
Post a Comment