public static string GetStorageEmulatorDBConnectionString() { string sqlInstance = null; StorageEmulatorUpdatableConfiguration storageEmulatorUpdatableConfiguration = null; if (StorageEmulatorUpdatableConfiguration.TryGetFromUserProfile(out storageEmulatorUpdatableConfiguration)) { sqlInstance = storageEmulatorUpdatableConfiguration.SqlInstance; } string database = null; using (SqlConnection sqlConnection = new SqlConnection(StorageEmulatorUpdatableConfiguration.GetDbConnectionString())) { if (sqlInstance == null) { sqlInstance = sqlConnection.DataSource; } database = sqlConnection.Database; } return(string.Format("Server={0};Integrated security=SSPI;database={1}", sqlInstance, database)); }
public static string GetSqlInstance() { string sqlInstance = null; StorageEmulatorUpdatableConfiguration storageEmulatorUpdatableConfiguration = null; if (StorageEmulatorUpdatableConfiguration.TryGetFromUserProfile(out storageEmulatorUpdatableConfiguration)) { sqlInstance = storageEmulatorUpdatableConfiguration.SqlInstance; } if (sqlInstance == null) { using (SqlConnection sqlConnection = new SqlConnection(StorageEmulatorUpdatableConfiguration.GetDbConnectionString())) { if (sqlInstance == null) { sqlInstance = sqlConnection.DataSource; } } } return(sqlInstance); }