private static async Task <HashSet <string> > GetEnumTableNames() { string query = TableQueryHelpers.GetTableNames(SchemaConstants.Enum); using var cmd = new SqlCommand(query, _connection); using SqlDataReader reader = await cmd.ExecuteReaderAsync(); return(reader.Cast <IDataRecord>().Select(r => (string)r[0]).ToHashSet()); }
private static async Task CreateTable(string tableName) { _logger.Debug($"[{_connection.Database}]: Creating table {SchemaConstants.Enum}.{tableName}..."); string command = TableQueryHelpers.CreateBasicTable(SchemaConstants.Enum, tableName); await _connection.ExecuteNonQueryAsync(command); _logger.Debug($"[{_connection.Database}]: Created table {SchemaConstants.Enum}.{tableName}."); }
private static async Task RecreateType() { _logger.Debug($"[{_connection.Database}]: Recreating {SchemaConstants.Enum}.{TypeName}..."); await _connection.ExecuteNonQueryAsync(TableQueryHelpers.RecreateType(SchemaConstants.Enum, TypeName)); }
public void CreatePointQueryFilterForPartitionAndRowKey_PropertyTests(string partitionKey, string rowKey) { TableQueryHelpers.CreatePointQueryFilterForPartitionAndRowKey(partitionKey, rowKey).Should().NotBeNull(); }