Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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);
        }