DbProviderUtils
Namespace: MJCZone.DapperMatic.Providers
Assembly: MJCZone.DapperMatic
Summary
Utility class for generating database constraint and index names.
static public
Contents
Methods (11)
Methods
| Method | Summary |
|---|---|
| GenerateCheckConstraintName | Generates a check constraint name. |
| GenerateDefaultConstraintName | Generates a default constraint name. |
| GenerateUniqueConstraintName | Generates a unique constraint name. |
| GeneratePrimaryKeyConstraintName | Generates a primary key constraint name. |
| GenerateIndexName | Generates an index name. |
| GenerateForeignKeyConstraintName | Generates a foreign key constraint name. |
| GenerateForeignKeyConstraintName | Generates a foreign key constraint name. |
| GetType | |
| ToString | |
| Equals | |
| GetHashCode |
GenerateCheckConstraintName
Generates a check constraint name.
csharp
string GenerateCheckConstraintName(string tableName, string columnName)Parameters
- tableName (string) - The name of the table.
- columnName (string) - The name of the column.
Returns
Type: string
The generated check constraint name.
GenerateDefaultConstraintName
Generates a default constraint name.
csharp
string GenerateDefaultConstraintName(string tableName, string columnName)Parameters
- tableName (string) - The name of the table.
- columnName (string) - The name of the column.
Returns
Type: string
The generated default constraint name.
GenerateUniqueConstraintName
Generates a unique constraint name.
csharp
GenerateUniqueConstraintName(string tableName, String[] columnNames)Parameters
- tableName (string) - The name of the table.
- columnNames (String[]) - The names of the columns.
Returns
The generated unique constraint name.
GeneratePrimaryKeyConstraintName
Generates a primary key constraint name.
csharp
GeneratePrimaryKeyConstraintName(string tableName, String[] columnNames)Parameters
- tableName (string) - The name of the table.
- columnNames (String[]) - The names of the columns.
Returns
The generated primary key constraint name.
GenerateIndexName
Generates an index name.
csharp
GenerateIndexName(string tableName, String[] columnNames)Parameters
- tableName (string) - The name of the table.
- columnNames (String[]) - The names of the columns.
Returns
The generated index name.
GenerateForeignKeyConstraintName
Generates a foreign key constraint name.
csharp
string GenerateForeignKeyConstraintName(
string tableName,
string columnName,
string refTableName,
string refColumnName)Parameters
- tableName (string) - The name of the table.
- columnName (string) - The name of the column.
- refTableName (string) - The name of the referenced table.
- refColumnName (string) - The name of the referenced column.
Returns
Type: string
The generated foreign key constraint name.
GenerateForeignKeyConstraintName
Generates a foreign key constraint name.
csharp
GenerateForeignKeyConstraintName(
string tableName,
String[] columnNames,
string refTableName,
String[] refColumnNames)Parameters
- tableName (string) - The name of the table.
- columnNames (String[]) - The names of the columns.
- refTableName (string) - The name of the referenced table.
- refColumnNames (String[]) - The names of the referenced columns.
Returns
The generated foreign key constraint name.
GetType
csharp
GetType()ToString
csharp
ToString()Equals
csharp
Equals()GetHashCode
csharp
GetHashCode()