SqlServerDesignStrings SqlServerDesignStrings Class

This API supports the Entity Framework Core infrastructure and is not intended to be used directly from your code. This API may change or be removed in future releases.

Syntax

Declaration

public static class SqlServerDesignStringsPublic Module SqlServerDesignStrings

Inheritance Hierarchy

  • System.Object
    System.Object
  • SqlServerDesignStrings
    SqlServerDesignStrings

Inherited Members

ToString(),
ToString(),
Equals(Object),
Equals(Object),
Equals(Object, Object),
Equals(Object, Object),
ReferenceEquals(Object, Object),
ReferenceEquals(Object, Object),
GetHashCode(),
GetHashCode(),
GetType(),
GetType(),
MemberwiseClone()
MemberwiseClone()

Methods summary

For column {columnId} unable to interpret computed value {computedValue}. Will not generate code setting a computed value for the property {propertyName} on entity type {entityTypeName}.

For column {columnId} unable to interpret default value {defaultValue}. Will not generate code setting a default value for the property {propertyName} on entity type {entityTypeName}.

Found a column on foreign key [{schemaName}].[{tableName}].[{fkName}] with an empty or null name. Not including column in foreign key

Found a column on index [{schemaName}].[{tableName}].[{indexName}] with an empty or null name. Not including column in index.

Found a column on table [{schemaName}].[{tableName}] with an empty or null name. Skipping column.

Column {columnName} belongs to table [{schema}].[{tableName}] which is not included in the selection set. Skipping.

For column {columnId}. This column is set up as an Identity column, but the SQL Server data type is {sqlServerDataType}. This will be mapped to CLR type byte which does not allow the SqlServerValueGenerationStrategy.IdentityColumn setting. Generating a matching Property but ignoring the Identity setting.

Foreign key column {columnName} belongs to foreign key {fkName} on table [{schema}].[{tableName}] which is not included in the selection set. Skipping.

Found a foreign key on table [{schemaName}].[{tableName}] with an empty or null name. Skipping foreign key.

Found column with schema: {schema}, table: {tableName}, column name: {columnName}, data type: {dataType}, ordinal: {ordinal}, nullable: {isNullable}, primary key ordinal: {primaryKeyOrdinal}, default value: {defaultValue}, computed value: {computedValue}, precision: {precision}, scale: {scale}, maximum length: {maxLength}, identity: {isIdentity}, computed: {isComputed}.

Found default schema {defaultSchema}.

Found foreign key column with schema: {schema}, table: {tableName}, foreign key name: {fkName}, principal table schema: {principalTableSchema}, principal table: {principalTableName}, column name: {columnName}, principal column name: {principalColumnName}, update action: {updateAction}, delete action: {deleteAction}, ordinal: {ordinal}.

Found index column with schema: {schema}, table: {tableName}, index name: {indexName}, unique: {isUnique}, type description: {typeDesc}, column name: {columnName}, ordinal: {ordinal}.

Found sequence with schema: {schema}, name: {name}, data type: {dataType}, cyclic: {isCyclic}, increment: {increment}, start: {start}, minimum: {min}, maximum: {max}.

Found table with schema: {schema}, name: {name}.

Found type alias {alias} which maps to underlying data type {dataType}.

Index column {columnName} belongs to index {indexName} on table [{schema}].[{tableName}] which is not included in the selection set. Skipping.

Found an index on table [{schemaName}].[{tableName}] with an empty or null name. Skipping index.

For foreign key {fkName} on table [{schema}].[{tableName}], unable to model the end of the foreign key on principal table [{principalTableSchema}].[{principalTableName}]. This is usually because the principal table was not included in the selection set.

Found a sequence in schema [{schemaName}] with an empty or null name. Skipping sequence.

Table [{schema}].[{tableName}] is not included in the selection set. Skipping.

For column {columnId} unable to convert default value {defaultValue} into type {propertyType}. Will not generate code setting a default value for the property {propertyName} on entity type {entityTypeName}.

Foreign Key {fkName} contains a column named {columnName} which cannot be found on table [{schemaName}].[{tableName}]. Not including column in foreign key.

Index {indexName} contains a column named {columnName} which cannot be found on table [{schemaName}].[{tableName}]. Not including column in index.

For column {columnName}. Unable to find parent table [{schemaName}].[{tablename}]. Skipping column.

For index {indexName}. Unable to find parent table [{schemaName}].[{tableName}]. Skipping index.

Methods

  • CannotInterpretComputedValue(Object, Object, Object, Object)
    CannotInterpretComputedValue(Object, Object, Object, Object)

    For column {columnId} unable to interpret computed value {computedValue}. Will not generate code setting a computed value for the property {propertyName} on entity type {entityTypeName}.

    public static string CannotInterpretComputedValue(object columnId, object computedValue, object propertyName, object entityTypeName)Public Shared Function CannotInterpretComputedValue(columnId As Object, computedValue As Object, propertyName As Object, entityTypeName As Object) As String

    Parameters

    • columnId
      System.Object
      System.Object
    • computedValue
      System.Object
      System.Object
    • propertyName
      System.Object
      System.Object
    • entityTypeName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • CannotInterpretDefaultValue(Object, Object, Object, Object)
    CannotInterpretDefaultValue(Object, Object, Object, Object)

    For column {columnId} unable to interpret default value {defaultValue}. Will not generate code setting a default value for the property {propertyName} on entity type {entityTypeName}.

    public static string CannotInterpretDefaultValue(object columnId, object defaultValue, object propertyName, object entityTypeName)Public Shared Function CannotInterpretDefaultValue(columnId As Object, defaultValue As Object, propertyName As Object, entityTypeName As Object) As String

    Parameters

    • columnId
      System.Object
      System.Object
    • defaultValue
      System.Object
      System.Object
    • propertyName
      System.Object
      System.Object
    • entityTypeName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • ColumnNameEmptyOnForeignKey(Object, Object, Object)
    ColumnNameEmptyOnForeignKey(Object, Object, Object)

    Found a column on foreign key [{schemaName}].[{tableName}].[{fkName}] with an empty or null name. Not including column in foreign key

    public static string ColumnNameEmptyOnForeignKey(object schemaName, object tableName, object fkName)Public Shared Function ColumnNameEmptyOnForeignKey(schemaName As Object, tableName As Object, fkName As Object) As String

    Parameters

    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object
    • fkName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • ColumnNameEmptyOnIndex(Object, Object, Object)
    ColumnNameEmptyOnIndex(Object, Object, Object)

    Found a column on index [{schemaName}].[{tableName}].[{indexName}] with an empty or null name. Not including column in index.

    public static string ColumnNameEmptyOnIndex(object schemaName, object tableName, object indexName)Public Shared Function ColumnNameEmptyOnIndex(schemaName As Object, tableName As Object, indexName As Object) As String

    Parameters

    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object
    • indexName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • ColumnNameEmptyOnTable(Object, Object)
    ColumnNameEmptyOnTable(Object, Object)

    Found a column on table [{schemaName}].[{tableName}] with an empty or null name. Skipping column.

    public static string ColumnNameEmptyOnTable(object schemaName, object tableName)Public Shared Function ColumnNameEmptyOnTable(schemaName As Object, tableName As Object) As String

    Parameters

    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • ColumnNotInSelectionSet(Object, Object, Object)
    ColumnNotInSelectionSet(Object, Object, Object)

    Column {columnName} belongs to table [{schema}].[{tableName}] which is not included in the selection set. Skipping.

    public static string ColumnNotInSelectionSet(object columnName, object schema, object tableName)Public Shared Function ColumnNotInSelectionSet(columnName As Object, schema As Object, tableName As Object) As String

    Parameters

    • columnName
      System.Object
      System.Object
    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • DataTypeDoesNotAllowSqlServerIdentityStrategy(Object, Object)
    DataTypeDoesNotAllowSqlServerIdentityStrategy(Object, Object)

    For column {columnId}. This column is set up as an Identity column, but the SQL Server data type is {sqlServerDataType}. This will be mapped to CLR type byte which does not allow the SqlServerValueGenerationStrategy.IdentityColumn setting. Generating a matching Property but ignoring the Identity setting.

    public static string DataTypeDoesNotAllowSqlServerIdentityStrategy(object columnId, object sqlServerDataType)Public Shared Function DataTypeDoesNotAllowSqlServerIdentityStrategy(columnId As Object, sqlServerDataType As Object) As String

    Parameters

    • columnId
      System.Object
      System.Object
    • sqlServerDataType
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • ForeignKeyColumnNotInSelectionSet(Object, Object, Object, Object)
    ForeignKeyColumnNotInSelectionSet(Object, Object, Object, Object)

    Foreign key column {columnName} belongs to foreign key {fkName} on table [{schema}].[{tableName}] which is not included in the selection set. Skipping.

    public static string ForeignKeyColumnNotInSelectionSet(object columnName, object fkName, object schema, object tableName)Public Shared Function ForeignKeyColumnNotInSelectionSet(columnName As Object, fkName As Object, schema As Object, tableName As Object) As String

    Parameters

    • columnName
      System.Object
      System.Object
    • fkName
      System.Object
      System.Object
    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • ForeignKeyNameEmpty(Object, Object)
    ForeignKeyNameEmpty(Object, Object)

    Found a foreign key on table [{schemaName}].[{tableName}] with an empty or null name. Skipping foreign key.

    public static string ForeignKeyNameEmpty(object schemaName, object tableName)Public Shared Function ForeignKeyNameEmpty(schemaName As Object, tableName As Object) As String

    Parameters

    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundColumn(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
    FoundColumn(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

    Found column with schema: {schema}, table: {tableName}, column name: {columnName}, data type: {dataType}, ordinal: {ordinal}, nullable: {isNullable}, primary key ordinal: {primaryKeyOrdinal}, default value: {defaultValue}, computed value: {computedValue}, precision: {precision}, scale: {scale}, maximum length: {maxLength}, identity: {isIdentity}, computed: {isComputed}.

    public static string FoundColumn(object schema, object tableName, object columnName, object dataType, object ordinal, object isNullable, object primaryKeyOrdinal, object defaultValue, object computedValue, object precision, object scale, object maxLength, object isIdentity, object isComputed)Public Shared Function FoundColumn(schema As Object, tableName As Object, columnName As Object, dataType As Object, ordinal As Object, isNullable As Object, primaryKeyOrdinal As Object, defaultValue As Object, computedValue As Object, precision As Object, scale As Object, maxLength As Object, isIdentity As Object, isComputed As Object) As String

    Parameters

    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object
    • columnName
      System.Object
      System.Object
    • dataType
      System.Object
      System.Object
    • ordinal
      System.Object
      System.Object
    • isNullable
      System.Object
      System.Object
    • primaryKeyOrdinal
      System.Object
      System.Object
    • defaultValue
      System.Object
      System.Object
    • computedValue
      System.Object
      System.Object
    • precision
      System.Object
      System.Object
    • scale
      System.Object
      System.Object
    • maxLength
      System.Object
      System.Object
    • isIdentity
      System.Object
      System.Object
    • isComputed
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundDefaultSchema(Object)
    FoundDefaultSchema(Object)

    Found default schema {defaultSchema}.

    public static string FoundDefaultSchema(object defaultSchema)Public Shared Function FoundDefaultSchema(defaultSchema As Object) As String

    Parameters

    • defaultSchema
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundForeignKeyColumn(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
    FoundForeignKeyColumn(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

    Found foreign key column with schema: {schema}, table: {tableName}, foreign key name: {fkName}, principal table schema: {principalTableSchema}, principal table: {principalTableName}, column name: {columnName}, principal column name: {principalColumnName}, update action: {updateAction}, delete action: {deleteAction}, ordinal: {ordinal}.

    public static string FoundForeignKeyColumn(object schema, object tableName, object fkName, object principalTableSchema, object principalTableName, object columnName, object principalColumnName, object updateAction, object deleteAction, object ordinal)Public Shared Function FoundForeignKeyColumn(schema As Object, tableName As Object, fkName As Object, principalTableSchema As Object, principalTableName As Object, columnName As Object, principalColumnName As Object, updateAction As Object, deleteAction As Object, ordinal As Object) As String

    Parameters

    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object
    • fkName
      System.Object
      System.Object
    • principalTableSchema
      System.Object
      System.Object
    • principalTableName
      System.Object
      System.Object
    • columnName
      System.Object
      System.Object
    • principalColumnName
      System.Object
      System.Object
    • updateAction
      System.Object
      System.Object
    • deleteAction
      System.Object
      System.Object
    • ordinal
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundIndexColumn(Object, Object, Object, Object, Object, Object, Object)
    FoundIndexColumn(Object, Object, Object, Object, Object, Object, Object)

    Found index column with schema: {schema}, table: {tableName}, index name: {indexName}, unique: {isUnique}, type description: {typeDesc}, column name: {columnName}, ordinal: {ordinal}.

    public static string FoundIndexColumn(object schema, object tableName, object indexName, object isUnique, object typeDesc, object columnName, object ordinal)Public Shared Function FoundIndexColumn(schema As Object, tableName As Object, indexName As Object, isUnique As Object, typeDesc As Object, columnName As Object, ordinal As Object) As String

    Parameters

    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object
    • indexName
      System.Object
      System.Object
    • isUnique
      System.Object
      System.Object
    • typeDesc
      System.Object
      System.Object
    • columnName
      System.Object
      System.Object
    • ordinal
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundSequence(Object, Object, Object, Object, Object, Object, Object, Object)
    FoundSequence(Object, Object, Object, Object, Object, Object, Object, Object)

    Found sequence with schema: {schema}, name: {name}, data type: {dataType}, cyclic: {isCyclic}, increment: {increment}, start: {start}, minimum: {min}, maximum: {max}.

    public static string FoundSequence(object schema, object name, object dataType, object isCyclic, object increment, object start, object min, object max)Public Shared Function FoundSequence(schema As Object, name As Object, dataType As Object, isCyclic As Object, increment As Object, start As Object, min As Object, max As Object) As String

    Parameters

    • schema
      System.Object
      System.Object
    • name
      System.Object
      System.Object
    • dataType
      System.Object
      System.Object
    • isCyclic
      System.Object
      System.Object
    • increment
      System.Object
      System.Object
    • start
      System.Object
      System.Object
    • min
      System.Object
      System.Object
    • max
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundTable(Object, Object)
    FoundTable(Object, Object)

    Found table with schema: {schema}, name: {name}.

    public static string FoundTable(object schema, object name)Public Shared Function FoundTable(schema As Object, name As Object) As String

    Parameters

    • schema
      System.Object
      System.Object
    • name
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • FoundTypeAlias(Object, Object)
    FoundTypeAlias(Object, Object)

    Found type alias {alias} which maps to underlying data type {dataType}.

    public static string FoundTypeAlias(object alias, object dataType)Public Shared Function FoundTypeAlias(alias As Object, dataType As Object) As String

    Parameters

    • alias
      System.Object
      System.Object
    • dataType
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • IndexColumnNotInSelectionSet(Object, Object, Object, Object)
    IndexColumnNotInSelectionSet(Object, Object, Object, Object)

    Index column {columnName} belongs to index {indexName} on table [{schema}].[{tableName}] which is not included in the selection set. Skipping.

    public static string IndexColumnNotInSelectionSet(object columnName, object indexName, object schema, object tableName)Public Shared Function IndexColumnNotInSelectionSet(columnName As Object, indexName As Object, schema As Object, tableName As Object) As String

    Parameters

    • columnName
      System.Object
      System.Object
    • indexName
      System.Object
      System.Object
    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • IndexNameEmpty(Object, Object)
    IndexNameEmpty(Object, Object)

    Found an index on table [{schemaName}].[{tableName}] with an empty or null name. Skipping index.

    public static string IndexNameEmpty(object schemaName, object tableName)Public Shared Function IndexNameEmpty(schemaName As Object, tableName As Object) As String

    Parameters

    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • PrincipalTableNotInSelectionSet(Object, Object, Object, Object, Object)
    PrincipalTableNotInSelectionSet(Object, Object, Object, Object, Object)

    For foreign key {fkName} on table [{schema}].[{tableName}], unable to model the end of the foreign key on principal table [{principalTableSchema}].[{principalTableName}]. This is usually because the principal table was not included in the selection set.

    public static string PrincipalTableNotInSelectionSet(object fkName, object schema, object tableName, object principalTableSchema, object principalTableName)Public Shared Function PrincipalTableNotInSelectionSet(fkName As Object, schema As Object, tableName As Object, principalTableSchema As Object, principalTableName As Object) As String

    Parameters

    • fkName
      System.Object
      System.Object
    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object
    • principalTableSchema
      System.Object
      System.Object
    • principalTableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • SequenceNameEmpty(Object)
    SequenceNameEmpty(Object)

    Found a sequence in schema [{schemaName}] with an empty or null name. Skipping sequence.

    public static string SequenceNameEmpty(object schemaName)Public Shared Function SequenceNameEmpty(schemaName As Object) As String

    Parameters

    • schemaName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • TableNotInSelectionSet(Object, Object)
    TableNotInSelectionSet(Object, Object)

    Table [{schema}].[{tableName}] is not included in the selection set. Skipping.

    public static string TableNotInSelectionSet(object schema, object tableName)Public Shared Function TableNotInSelectionSet(schema As Object, tableName As Object) As String

    Parameters

    • schema
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • UnableToConvertDefaultValue(Object, Object, Object, Object, Object)
    UnableToConvertDefaultValue(Object, Object, Object, Object, Object)

    For column {columnId} unable to convert default value {defaultValue} into type {propertyType}. Will not generate code setting a default value for the property {propertyName} on entity type {entityTypeName}.

    public static string UnableToConvertDefaultValue(object columnId, object defaultValue, object propertyType, object propertyName, object entityTypeName)Public Shared Function UnableToConvertDefaultValue(columnId As Object, defaultValue As Object, propertyType As Object, propertyName As Object, entityTypeName As Object) As String

    Parameters

    • columnId
      System.Object
      System.Object
    • defaultValue
      System.Object
      System.Object
    • propertyType
      System.Object
      System.Object
    • propertyName
      System.Object
      System.Object
    • entityTypeName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • UnableToFindColumnForForeignKey(Object, Object, Object, Object)
    UnableToFindColumnForForeignKey(Object, Object, Object, Object)

    Foreign Key {fkName} contains a column named {columnName} which cannot be found on table [{schemaName}].[{tableName}]. Not including column in foreign key.

    public static string UnableToFindColumnForForeignKey(object fkName, object columnName, object schemaName, object tableName)Public Shared Function UnableToFindColumnForForeignKey(fkName As Object, columnName As Object, schemaName As Object, tableName As Object) As String

    Parameters

    • fkName
      System.Object
      System.Object
    • columnName
      System.Object
      System.Object
    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • UnableToFindColumnForIndex(Object, Object, Object, Object)
    UnableToFindColumnForIndex(Object, Object, Object, Object)

    Index {indexName} contains a column named {columnName} which cannot be found on table [{schemaName}].[{tableName}]. Not including column in index.

    public static string UnableToFindColumnForIndex(object indexName, object columnName, object schemaName, object tableName)Public Shared Function UnableToFindColumnForIndex(indexName As Object, columnName As Object, schemaName As Object, tableName As Object) As String

    Parameters

    • indexName
      System.Object
      System.Object
    • columnName
      System.Object
      System.Object
    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • UnableToFindTableForColumn(Object, Object, Object)
    UnableToFindTableForColumn(Object, Object, Object)

    For column {columnName}. Unable to find parent table [{schemaName}].[{tablename}]. Skipping column.

    public static string UnableToFindTableForColumn(object columnName, object schemaName, object tablename)Public Shared Function UnableToFindTableForColumn(columnName As Object, schemaName As Object, tablename As Object) As String

    Parameters

    • columnName
      System.Object
      System.Object
    • schemaName
      System.Object
      System.Object
    • tablename
      System.Object
      System.Object

    Returns

    • System.String
      System.String
  • UnableToFindTableForIndex(Object, Object, Object)
    UnableToFindTableForIndex(Object, Object, Object)

    For index {indexName}. Unable to find parent table [{schemaName}].[{tableName}]. Skipping index.

    public static string UnableToFindTableForIndex(object indexName, object schemaName, object tableName)Public Shared Function UnableToFindTableForIndex(indexName As Object, schemaName As Object, tableName As Object) As String

    Parameters

    • indexName
      System.Object
      System.Object
    • schemaName
      System.Object
      System.Object
    • tableName
      System.Object
      System.Object

    Returns

    • System.String
      System.String

Details

Assembly

Microsoft.EntityFrameworkCore.SqlServer.Design.dll