public SQLDBRepository(SQLDBRepositorySettings settings) { if (settings == null) { throw new ArgumentNullException(); } _Settings = settings; _sConnectionString = MakeConnectionString(_Settings); }
public SQLDBRepository(string settingsXmlFileName) { if (string.IsNullOrEmpty(settingsXmlFileName)) { throw new ArgumentNullException(); } var xml = new XmlSerializer(typeof(SQLDBRepositorySettings)); using (var sr = new StreamReader(settingsXmlFileName)) { _Settings = xml.Deserialize(sr) as SQLDBRepositorySettings; } _sConnectionString = MakeConnectionString(_Settings); }
private string MakeConnectionString(SQLDBRepositorySettings settings) { if (String.IsNullOrEmpty(settings.User)) { if (settings.SQLServerPort != 0) { return(String.Format(@"data source={0},{2};initial catalog={1};integrated security=True;", settings.SQLServerAddr, settings.Database, settings.SQLServerPort)); } else { return(String.Format(@"data source={0};initial catalog={1};integrated security=True;", settings.SQLServerAddr, settings.Database)); } } else { if (settings.SQLServerPort != 0) { return(String.Format(@"data source={0},{4};initial catalog={1};UID={2};PWD={3};integrated security=false;", settings.SQLServerAddr, settings.Database, settings.User, settings.Password, settings.SQLServerPort)); } else { return(String.Format(@"data source={0};initial catalog={1};UID={2};PWD={3};integrated security=false;", settings.SQLServerAddr, settings.Database, settings.User, settings.Password)); } } }