/// <summary> /// Returns true if given database has memory optimized filegroup on given server. /// </summary> /// <param name="server"></param> /// <param name="dbName"></param> /// <returns></returns> public static bool HasMemoryOptimizedFileGroup(SMO.Server server, string dbName) { bool hasMemoryOptimizedFileGroup = false; if (server.ServerType != DatabaseEngineType.SqlAzureDatabase) { string query = string.Format(CultureInfo.InvariantCulture, "select top 1 1 from [{0}].sys.filegroups where type = 'FX'", CUtils.EscapeString(dbName, ']')); if (server.ConnectionContext.ExecuteScalar(query) != null) { hasMemoryOptimizedFileGroup = true; } } return(hasMemoryOptimizedFileGroup); }
/// <summary> /// Creates the ALTER DATABASE statement from the given op /// </summary> /// <returns></returns> private static string CreateAzureAlterDbStatement(string dbName, string options) { return(string.Format(CultureInfo.InvariantCulture, AlterDbStatementFormat, CUtils.EscapeString(CUtils.EscapeString(dbName, ']'), '\''), options)); }
/// <summary> /// Function doubles up '\'' character in a string /// </summary> /// <param name="s"></param> /// <returns></returns> public static String EscapeStringSQuote(string s) { return(CUtils.EscapeString(s, '\'')); }
/// <summary> /// Function doubles up ']' character in a string /// </summary> /// <param name="s"></param> /// <returns></returns> public static String EscapeStringCBracket(string s) { return(CUtils.EscapeString(s, ']')); }