SqlEntity (SQLProvider)

SqlEntity Type

Namespace: FSharp.Data.Sql.Common
Assembly: FSharp.Data.SqlProvider.dll
Base Type: obj
All Interfaces: ICustomTypeDescriptor , INotifyPropertyChanged

Constructors

Constructor Description

Constructor	Description
`SqlEntity(dc, tableName, columns)` Full Usage: `SqlEntity(dc, tableName, columns)` Parameters: dc : `ISqlDataContext` tableName : `string` columns : `ColumnLookup` Returns: `SqlEntity`	dc : `ISqlDataContext` tableName : `string` columns : `ColumnLookup` Returns: `SqlEntity`


                
                  
                    
                      SqlEntity(dc, tableName, columns)

Full Usage: SqlEntity(dc, tableName, columns)

Parameters:

dc : ISqlDataContext

tableName : string

columns : ColumnLookup

Returns: SqlEntity

dc : ISqlDataContext
tableName : string
columns : ColumnLookup

Returns: SqlEntity

Instance members

Instance member	Description
`this.Clone` Full Usage: `this.Clone` Returns: `SqlEntity`	Makes a copy of entity (database row), which is a new row with the same columns and values (except Id) If column primaty key is something else and not-auto-generated, then, too bad... Returns: `SqlEntity`
`this.CloneTo` Full Usage: `this.CloneTo` Parameters: secondContext : `ISqlDataContext` itemExistsAlready : `bool` Returns: `SqlEntity`	Attach/copy entity to a different data-context. Second parameter: SQL UPDATE or INSERT clause? UPDATE: Updates the exising database entity with the values that this entity contains. INSERT: Makes a copy of entity (database row), which is a new row with the same columns and values (except Id) secondContext : `ISqlDataContext` itemExistsAlready : `bool` Returns: `SqlEntity`
`this.ColumnValues` Full Usage: `this.ColumnValues` Returns: `(string * obj) seq`	Returns: `(string * obj) seq`
`this.DataContext` Full Usage: `this.DataContext` Returns: `ISqlDataContext`	Returns: `ISqlDataContext`
`this.Delete` Full Usage: `this.Delete`
`this.GetColumn` Full Usage: `this.GetColumn` Parameters: key : `string` Returns: `'T`	key : `string` Returns: `'T`
`this.GetColumnOption` Full Usage: `this.GetColumnOption` Parameters: key : `string` Returns: `Option<'T>`	key : `string` Returns: `Option<'T>`
`this.GetColumnValueOption` Full Usage: `this.GetColumnValueOption` Parameters: key : `string` Returns: `ValueOption<'T>`	key : `string` Returns: `ValueOption<'T>`
`this.GetPkColumnOption` Full Usage: `this.GetPkColumnOption` Parameters: keys : `string list` Returns: `'T list`	keys : `string list` Returns: `'T list`
`this.HasColumn` Full Usage: `this.HasColumn` Parameters: key : `string` ?comparison : `StringComparison` Returns: `bool`	key : `string` ?comparison : `StringComparison` Returns: `bool`
`this.HasValue` Full Usage: `this.HasValue` Parameters: key : `string` Returns: `bool`	key : `string` Returns: `bool`
`this.MapTo` Full Usage: `this.MapTo` Parameters: ?propertyTypeMapping : `string * obj -> obj` Returns: `'a`	?propertyTypeMapping : `string * obj -> obj` Returns: `'a`
`this.OnConflict` Full Usage: `this.OnConflict`	Determines what should happen when saving this entity if it is newly-created but another entity with the same primary key already exists
`this.SetColumn` Full Usage: `this.SetColumn` Parameters: key : `string` value : `'t`	key : `string` value : `'t`
`this.SetColumnOption` Full Usage: `this.SetColumnOption` Parameters: key : `string` value : `'a option`	key : `string` value : `'a option`
`this.SetColumnOptionSilent` Full Usage: `this.SetColumnOptionSilent` Parameters: key : `string` value : `'a option`	key : `string` value : `'a option`
`this.SetColumnSilent` Full Usage: `this.SetColumnSilent` Parameters: key : `string` value : `'a`	key : `string` value : `'a`
`this.SetColumnValueOption` Full Usage: `this.SetColumnValueOption` Parameters: key : `string` value : `'a voption`	key : `string` value : `'a voption`
`this.SetData` Full Usage: `this.SetData` Parameters: data : `(string * 'f) seq`	data : `(string * 'f) seq`
`this.SetPkColumnOptionSilent` Full Usage: `this.SetPkColumnOptionSilent` Parameters: keys : `string list` value : `'a option`	keys : `string list` value : `'a option`
`this.SetPkColumnSilent` Full Usage: `this.SetPkColumnSilent` Parameters: keys : `string list` value : `'a`	keys : `string list` value : `'a`
`this.Table` Full Usage: `this.Table` Returns: `Table`	Returns: `Table`
`this._State` Full Usage: `this._State`