Click or drag to resize

SqlColumnBaseDefinition Class

Definition of a SQL column used to ensure a column in a database.
Inheritance Hierarchy
SystemObject
  MicaSystems.UtilsSqlColumnBaseDefinition

Namespace:  MicaSystems.Utils
Assembly:  MicaSystems.Utils (in MicaSystems.Utils.dll) Version: 1.0.0.0 (1.1.0.123)
Syntax
C#
public class SqlColumnBaseDefinition

The SqlColumnBaseDefinition type exposes the following members.

Constructors
  NameDescription
Public methodSqlColumnBaseDefinition
Top
Properties
  NameDescription
Public propertyAdaptFilter
Gets or sets an optionnal method that customizes filters before their insertion in an SQL query.
Public propertyAllowNulls
Gets or sets a value indicating whether the column must accept NULL value.
Public propertyColumnName
Gets or sets the name of the column in the database.
Public propertyColumnType
Gets or sets the sql type of the column.
Public propertyComplexTypeAsString
Gets or sets a value identifying an advanced type of values.
Public propertyCreateAs
Gets or sets a custom column name for its creation.
Public propertyHasComplexValue
Gets or sets a value indicating whether this column contains values that must be loaded into a more complex object.
Public propertyIdentifierType
Gets or sets a special behavior of the column in the database.
Public propertyIndexGroup
Gets or sets the name of the index on this column.

Use this property to group multiple columns inside a same index.

Public propertyNeverSave
Gets or sets a value indicating whether this column must be skipped for each save operation.
Public propertyOperationsSettings
Gets or sets an object changing the way this column should be used in various query operations.
Public propertySize
Gets or sets the size of the column.
Public propertyType
Gets the .Net type corresponding to this column SQL type.
Public propertyUseMaxSize
Gets or sets a value indicating whether this column must use MAX size.

Ex : nvarchar(MAX).

Public propertyValueInitialization
Method to call each time a value of this column is loaded from the database and is being placed in its object.
Top
Methods
  NameDescription
Public methodGetCreationColumnName
Gets the column name used to create this column.
Public methodGetCreationSQLCode
Generates the part of the query identifying the column for its creation.
Public methodGetSQLType
Generate the full SQL identification code for this column.

Ex : DECIMAL(38, 8) or NVARCHAR(MAX) or VARBINARY(255)

Public methodToString
Generates a display text identifying this column definition.
(Overrides ObjectToString.)
Top
Extension Methods
  NameDescription
Public Extension MethodAsT
Casts an object to another type. Returns default(T) if the object is null.
(Defined by Utils_Other.)
Public Extension MethodEqualsAll
Checks that this object is equal to every object in parameters.
(Defined by Utils_Other.)
Public Extension MethodEqualsAny
Checks that this object is equal to at least one of the parameters.
(Defined by Utils_Other.)
Public Extension MethodGetString
Converts an object to String using ToString() method, else returns String.Empty.
(Defined by Utils_Other.)
Public Extension MethodIsGenericListOverloaded.
Checks if this object is a System.Collections.Generic.List.
(Defined by Utils_Linq.)
Public Extension MethodIsGenericList(Type)Overloaded.
Checks if this object is a System.Collections.Generic.List using type as T.
(Defined by Utils_Linq.)
Public Extension MethodSerializeOverloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.)
Public Extension MethodSerialize(String)Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.)
Public Extension MethodSerializeJsonOverloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Public Extension MethodSerializeJson(ListType)Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Public Extension MethodSerializeJson(DataContractJsonSerializerSettings)Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.)
Top
See Also