DataObjects for .NET Overview
Help with WinForms Edition
Key Features
DataObjects for .NET Quick Start
Step 1 of 4: Setting up the Form and Importing a Database Structure
Step 2 of 4: Creating a Data Schema using the Schema Designer
Step 3 of 4: Binding the Data Source to a Grid
Step 4 of 4: Running the Program
DataObjects for .NET Top Tips
DataObjects for .NET (Enterprise Edition)
DataObjects for .NET and ADO.NET
Schema Objects
Importing Database Structure
Converting Schema from Other Sources
Database Structure Evolution and the Schema
Database Connections
Connections and Transactions at Run Time
Supporting Distributed (COM+) Transactions
Native and OLE DB Database Access
Using Other (Custom) .NET Data Providers
Simple Tables
Creating and Modifying Tables
Using Table Properties
Table Business Logic Events
Table Fields
Structured Data Storage: Tables and Table Views
How the Data is Fetched
How the Data is Modified
How to Access Table Data
Bound, SQL-Based, and Unbound Tables
Simple Relations
Creating and Modifying a Simple Relation
Simple Relation Properties
Composite Tables
Composite Table Diagram
Creating and Modifying Composite Table Diagrams
Composite Table Fields
Composite Table Properties and Business Logic Events
How Composite Table Data is Fetched, Stored, and Updated
How to Access Composite Table Data
Composite Relations
Data Sets
Creating and Modifying a Data Set Definition
Table Views
Table View Fields
Table View Business Logic Events
View Relations
Custom View Relations
How to Access Table View Data
Data Binding
Programmatic Access
Business Logic
How Business Logic Works on Different Levels
Business Logic Events
Events on Editing Row
Events on Modifying Row
Events on Adding Row
Events on Deleting Row
Events on Updating Database
Business Methods
Using Typed Data Objects
Action Order and Execution Mode
Application Configurations
Direct Client
Data Library
Creating a Data Library Project
Using a Data Library
2-Tier Application
3-Tier Application
Configuring the Data Library on the Server
Security Considerations
Virtual Mode – Dealing with Large Datasets
Understanding Large Data Sets
Table Views in Virtual Mode
When a Virtual Table View Fetches Data Segments
Virtual Mode in Distributed 3-Tier Applications
Using C1DataTableSource and Bound Controls
Asynchronous Fetch Modes
Sorting Data in Virtual Mode
Virtual Mode Restrictions
Necessary Requirements for Virtual Mode
Functionality Restrictions in Virtual Mode
Virtual Mode Performance Tuning
Updating the Database
When the Database is Updated
Update in 2-Tier and 3-Tier Configurations
Update Process on the Server
Generated SQL Statements
Deleted Row
Added Row
Modified Row
Events in Updating a Row
Changing Data as a Result of Update (Refresh)
Updating SQL-Based and Unbound Tables
Updating SQL-Based Tables
Updating Unbound Tables
Controlling the Update Process
Handling Errors in Update
Handling Concurrency Conflicts
Handling Update Errors on the Client
Features and Techniques
DataObjects for .NET Expressions
ADO.NET Expression Language Reference
Escaping Special Characters and Reserved Words
Constant Values
Operators
Parent/Child Fields
Aggregation Functions
Field Value Qualifying Functions
Other Functions
Adding Rows and Primary Keys
Keys Assigned by Client: New Row Detached and Attached State
Keys Assigned by Server or Database
Key Assigned Automatically by Database
Programmatic Key Assignment
Working with ADO.NET Dataset
DataObjects for .NET Enterprise Edition Design-Time Support
C1SchemaDef Tasks and Context Menus
C1DataSet Tasks and Context Menus
C1DataView Tasks and Context Menus
C1SchemaRef Tasks and Context Menus
C1TableLogic Tasks and Context Menus
C1DataTableSource Tasks and Context Menus
DataObjects for .NET Tutorials
Tutorial 1: Creating a Data Schema
Tutorial 2: Defining Business Logic
Tutorial 3: Creating Distributed 3-Tier Applications
Tutorial 4: Virtual Mode: Dealing with Large Datasets
DataObjects for .NET Express Edition
C1ExpressTable: Working with Simple and Composite Tables
Connecting to Database and Working with Data
Using Composite Tables
Defining Fields
DB Fields and Calculated Fields
Field Properties
Programmatic Access to Data
Customizing Data Logic with Events
C1ExpressConnection: Combining Tables into Data Sets
Defining Relations
Master-Detail Relations
Enforcing Referential Integrity (Foreign Key) Constraints
Relation Properties
C1ExpressView: Filtering, Sorting and Working with Tables in Other Forms
Working with Tables in Other Forms
DataObjects for .NET Express Design-Time Support
C1ExpressTable Tasks and Context Menus
C1ExpressConnection Tasks and Context Menus
C1ExpressView Tasks and Context Menus
Notes for Users of DataObjects for .NET Enterprise Edition
DataObjects for .NET Express Tutorials
Tutorial 1: Binding to a Simple Table
Tutorial 2: Creating a Composite Table
Tutorial 3: C1ExpressConnection and Master-Detail Relations
Tutorial 4: Using C1ExpressView Component
Tutorial 5: Customizing Data Behavior with Events
DataObjects for .NET Samples
DataObjects for .NET Task-Based Help
Avoiding a Memory Leak
Changing the Connection String
Creating a Composite Table Programmatically
Exporting Data from a C1DataSet to XML
Importing Schema Information using the Conversion Wizard
Using the C1SchemaRef Control
Creating a Schema with the Import Wizard
Creating and Customizing the Schema using the Schema Designer
Viewing the SQL Statement Generated when a TableView is Sorted
API Reference
C1.Data.2 Assembly
Namespaces
C1.Data Namespace
Overview
Classes
BaseDataSourceComponent
Overview
Members
Properties
DataTable Property
Position Property
Events
CurrentRowChanged Event
PositionChanged Event
BaseDataTableSource
Overview
Members
Methods
MoveFirst Method
MoveLast Method
MoveNext Method
MovePrevious Method
Seek Method
Properties
Count Property
CurrentRow Property
DataTable Property
UpdateLeavingRow Property
Events
AfterAddNew Event
AfterBeginEdit Event
AfterCancelEdit Event
AfterChanges Event
AfterDelete Event
AfterEndAddNew Event
AfterEndEdit Event
AfterFieldChange Event
AfterFirstChange Event
AsyncFetchComplete Event
BeforeAddNew Event
BeforeBeginEdit Event
BeforeCancelEdit Event
BeforeDelete Event
BeforeEndAddNew Event
BeforeEndEdit Event
BeforeFieldChange Event
BeforeFirstChange Event
BaseLogic
Overview
Members
Properties
Schema Property
SchemaComponent Property
Events
AfterAddNew Event
AfterBeginEdit Event
AfterCancelEdit Event
AfterChanges Event
AfterDelete Event
AfterEndAddNew Event
AfterEndEdit Event
AfterFieldChange Event
AfterFirstChange Event
AfterUpdateRow Event
BeforeAddNew Event
BeforeBeginEdit Event
BeforeCancelEdit Event
BeforeDelete Event
BeforeEndAddNew Event
BeforeEndEdit Event
BeforeFieldChange Event
BeforeFirstChange Event
BeforeUpdateRow Event
ChangesAccepted Event
ChangesRejected Event
C1DataException
Overview
Members
Properties
ErrorField Property
ErrorRow Property
ErrorTable Property
IsTable Property
IsTableView Property
ShowMessage Property
C1DataRow
Overview
Members
C1DataRow Constructor
Methods
AcceptChanges Method
BeginEdit Method
CancelEdit Method
ClearErrors Method
Delete Method
EndEdit Method
FromDataItem Method
GetChildRows Method
GetChildRows(String) Method
GetChildRows() Method
GetFieldError Method
GetFieldError(Int32) Method
GetFieldError(String) Method
GetFieldError(DataField) Method
GetFieldsInError Method
GetParentRow Method
GetParentRow(String) Method
GetParentRow() Method
HasVersion Method
IsNull Method
IsNull(Int32) Method
IsNull(String) Method
Refresh Method
RejectChanges Method
SetFieldError Method
SetFieldError(Int32,String) Method
SetFieldError(String,String) Method
SetFieldError(DataField,String) Method
SetNull Method
SetRowStateModified Method
Properties
DataItem Property
DataTable Property
ExtendedData Property
HasErrors Property
Item Property
Item(Int32) Property
Item(String) Property
Item(DataField) Property
Item(Int32,DataRowVersionEnum) Property
Item(String,DataRowVersionEnum) Property
Item(DataField,DataRowVersionEnum) Property
ItemArray Property
Modified Property
Ordinal Property
RowError Property
RowState Property
StorageDataRow Property
C1DataRowCollection
Overview
Members
Methods
Contains Method
CopyTo Method
Find Method
Find(Object) Method
Find(Object[]) Method
IndexOf Method
Properties
Count Property
Item Property
C1DataSet
Overview
Members
C1DataSet Constructor
Methods
AcceptChanges Method
Clear Method
Clear() Method
Clear(String[]) Method
Fill Method
Fill() Method
Fill(Boolean) Method
Fill(FilterCondition,Boolean) Method
Fill(FilterConditions,Boolean) Method
Fill(String[]) Method
Fill(FilterConditions,String[]) Method
GetChanges Method
GetChanges() Method
GetChanges(String[],DataRowStateEnum) Method
GetDefaultTableViewRows Method
GetExportDataSet Method
GetExportDataSet() Method
GetExportDataSet(Boolean) Method
HasChanges Method
HasChanges() Method
HasChanges(DataRowStateEnum) Method
Merge Method
PopExecutionMode Method
PushExecutionMode Method
ReadXml Method
ReadXml(String) Method
ReadXml(Stream) Method
ReadXml(XmlReader) Method
RejectChanges Method
SetTableViewRows Method
StopAsyncFetch Method
StorageChangeBegin Method
StorageChanged Method
StorageChanged() Method
StorageChanged(Boolean) Method
StorageChangeEnd Method
Update Method
Update() Method
Update(String[]) Method
WriteXml Method
WriteXml(String) Method
WriteXml(Stream) Method
WriteXml(XmlTextWriter) Method
Properties
CaseSensitive Property
ChangeInProgress Property
Credentials Property
DataLibrary Property
DataLibraryUrl Property
DataSetDef Property
DynamicConnections Property
EnforceConstraints Property
ExecutionMode Property
ExtendedProperties Property
Filled Property
FillOnRequest Property
HasErrors Property
Locale Property
NotificationModeFlags Property
RemoteDataService Property
Schema Property
SchemaContainer Property
SchemaDef Property
Site Property
SortComparisonMode Property
StorageDataSet Property
SuppressNotifications Property
Tables Property
TableViews Property
Events
AfterFill Event
BeforeFill Event
CurrentRowChanged Event
Error Event
PositionChanged Event
UpdateError Event
C1DataSetLogic
Overview
Members
C1DataSetLogic Constructor
Properties
DataSetDef Property
Events
AfterFetch Event
AfterGenerateSql Event
AfterUpdate Event
BeforeFetch Event
BeforeGenerateSql Event
BeforeUpdate Event
GetChildRows Event
GetParentRow Event
C1DataTable
Overview
Members
Methods
AcceptChanges Method
AddNew Method
Compute Method
GetErrors Method
Refresh Method
RejectChanges Method
ResetCaseSensitive Method
ResetSortComparisonMode Method
Properties
CaseSensitive Property
DataSet Property
ExtendedProperties Property
FetchIndex Property
Fields Property
HasErrors Property
Locale Property
Name Property
PrimaryKey Property
Rows Property
SchemaTable Property
SortComparisonMode Property
StorageDataTable Property
C1DataTableCollection
Overview
Members
Methods
CopyTo Method
IndexOf Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
Item(BaseTable) Property
C1DataTableSource
Overview
Members
C1DataTableSource Constructor
Properties
DataSet Property
TableView Property
C1DataView
Overview
Members
C1DataView Constructor
Methods
AddNew Method
Contains Method
CopyTo Method
CreateChildView Method
Delete Method
Find Method
Find(Object) Method
Find(Object[]) Method
IndexOf Method
Refresh Method
Refresh() Method
Refresh(Boolean) Method
Properties
AllowAddNew Property
AllowDelete Property
AutoRefresh Property
Count Property
DataSet Property
DataTable Property
DefaultDataView Property
IsDefault Property
Item Property
ReadOnly Property
RowFilter Property
RowStateFilter Property
Sort Property
Table Property
TableName Property
TableView Property
TableViewName Property
Events
GetRows Event
C1SchemaDef
Overview
Members
C1SchemaDef Constructor
Methods
Add Method
Properties
DataObjectsAssemblyFlags Property
RunsAt Property
Schema Property
SessionCacheProperties Property
Events
CreateSchema Event
C1SchemaRef
Overview
Members
C1SchemaRef Constructor
Properties
Schema Property
SchemaDef Property
C1TableLogic
Overview
Members
C1TableLogic Constructor
Properties
DataAdapter Property
Table Property
ConstraintCollection
Overview
Members
ConstraintCollection Constructor
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
Insert Method
Remove Method
Properties
Item Property
ConstraintException
Overview
Members
Properties
ErrorField Property
ErrorTable Property
ConstraintInfo
Overview
Members
ConstraintInfo Constructor
Properties
Condition Property
ErrorDescription Property
Expression Property
CurrentRowChangedEventArgs
Overview
Members
CurrentRowChangedEventArgs Constructor
Properties
ChangeType Property
CurrencyManager Property
DataMember Property
Position Property
Row Property
TableName Property
TableViewName Property
DataActionCanceledException
Overview
Members
DataField
Overview
Members
Properties
DataTable Property
DataType Property
ExtendedProperties Property
Name Property
Ordinal Property
SchemaField Property
StorageDataColumn Property
DataFieldCollection
Overview
Members
Methods
CopyTo Method
IndexOf Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
DataItem
Overview
Members
Properties
DataRow Property
Item Property
Item(Int32) Property
Item(String) Property
RowState Property
DataSetEventArgs
Overview
Members
Properties
DataSet Property
Error Property
Status Property
Tables Property
TableViews Property
DbAccessException
Overview
Members
Properties
Connection Property
DisabledOperationException
Overview
Members
Properties
Operation Property
ErrorEventArgs
Overview
Members
Properties
Error Property
ShowMessage Property
ExpressionException
Overview
Members
FetchEventArgs
Overview
Members
Properties
Command Property
Filter Property
Reader Property
Sql Property
Status Property
Tables Property
TableView Property
TableViews Property
FieldCalculationCollection
Overview
Members
FieldCalculationCollection Constructor
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
Insert Method
Remove Method
Properties
Item Property
FieldCalculationInfo
Overview
Members
FieldCalculationInfo Constructor
Properties
Condition Property
Expression Property
FireEvent Property
FieldChangeEventArgs
Overview
Members
Properties
DataTable Property
Field Property
NewValue Property
OldValue Property
Row Property
FillEventArgs
Overview
Members
Properties
DataSet Property
Filter Property
TableViewNames Property
FilterCondition
Overview
Members
FilterCondition Constructor
FilterCondition Constructor(TableView,String)
FilterCondition Constructor(TableView,String,Boolean)
FilterCondition Constructor(C1DataSet,String,String,Boolean)
FilterCondition Constructor(C1DataSet,String,String)
FilterCondition Constructor()
Properties
ConditionText Property
FillSort Property
IsCustom Property
TableView Property
FilterConditions
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
Insert Method
Remove Method
Properties
Item Property
GenerateSqlEventArgs
Overview
Members
Properties
ClauseFrom Property
ClauseOrderBy Property
ClauseSelect Property
ClauseWhere Property
Command Property
Filter Property
Sql Property
Status Property
TableView Property
GetListEventArgs
Overview
Members
Properties
List Property
RelationName Property
Row Property
InvalidDataOperationException
Overview
Members
OperationFailureException
Overview
Members
Properties
Operation Property
PositionChangeEventArgs
Overview
Members
Properties
CurrencyManager Property
DataMember Property
NewPosition Property
OldPosition Property
Row Property
PropertyCollection
Overview
Members
PropertyCollection Constructor
RemoteDataService
Overview
Members
Methods
Fill Method
Update Method
RowChangeEventArgs
Overview
Members
Properties
Action Property
DataTable Property
ItemArray Property
Modified Property
ParentRow Property
Row Property
RowUpdateEventArgs
Overview
Members
Properties
DeleteCommand Property
Error Property
InsertCommand Property
Row Property
SelectCommand Property
SqlStatus Property
Status Property
Tables Property
TableViews Property
UpdateCommand Property
SchemaBase
Overview
Members
Properties
Schema Property
SchemaException
Overview
Members
Properties
ObjectName Property
ObjectTypeName Property
SessionCacheProperties
Overview
Members
Properties
Compressed Property
DefaultStorage Property
StoragePath Property
UnboundDataReader
Overview
Members
UnboundDataReader Constructor
Properties
DataTable Property
Enumerations
CacheModeEnum
CacheStorageEnum
CommandTypeEnum
DataObjectsAssemblyFlags
DataRowActionEnum
DataRowStateEnum
DataRowVersionEnum
DataSetEventStatusEnum
DataViewRowStateEnum
ExecutionModeEnum
ListChangedFlags
OperationEnum
RowChangedTypeEnum
RowEventStatusEnum
RunsAtEnum
SortComparisonMode
SqlResultStatusEnum
UpdateModeEnum
Delegates
CurrentRowChangedEventHandler
DataSetEventHandler
ErrorEventHandler
FetchEventHandler
FieldChangeEventHandler
FillEventHandler
GenerateSqlEventHandler
GetListEventHandler
PositionChangeEventHandler
RowChangeEventHandler
RowUpdateEventHandler
C1.Data.SchemaObjects Namespace
Overview
Classes
BaseTable
Overview
Members
Properties
AllowAddNew Property
AllowDelete Property
ConstraintsFieldLevel Property
ConstraintsRecordLevel Property
Description Property
EffectiveAllowAddNew Property
EffectiveAllowDelete Property
EffectiveReadOnly Property
EffectiveUserReadOnly Property
Name Property
PrimaryKey Property
ReadOnly Property
RowType Property
UserReadOnly Property
C1CustomConnection
Overview
Members
C1CustomConnection Constructor
C1CustomConnection Constructor(Schema)
C1CustomConnection Constructor()
Properties
ConnectionType Property
CustomProviderInfo Property
C1MSOracleConnection
Overview
Members
C1MSOracleConnection Constructor
C1MSOracleConnection Constructor(Schema)
C1MSOracleConnection Constructor()
Properties
ConnectionStringDesc Property
ConnectionType Property
C1OleDbConnection
Overview
Members
C1OleDbConnection Constructor
C1OleDbConnection Constructor(Schema)
C1OleDbConnection Constructor()
Properties
ConnectionStringDesc Property
ConnectionType Property
C1OracleConnection
Overview
Members
C1OracleConnection Constructor
C1OracleConnection Constructor(Schema)
C1OracleConnection Constructor()
Properties
ConnectionStringDesc Property
ConnectionType Property
C1SqlServerCeConnection
Overview
Members
C1SqlServerCeConnection Constructor
C1SqlServerCeConnection Constructor(Schema)
C1SqlServerCeConnection Constructor()
Properties
ConnectionStringDesc Property
ConnectionType Property
C1SqlServerConnection
Overview
Members
C1SqlServerConnection Constructor
C1SqlServerConnection Constructor(Schema)
C1SqlServerConnection Constructor()
Properties
ConnectionStringDesc Property
ConnectionType Property
CacheProperties
Overview
Members
Properties
CacheCompressed Property
CacheMode Property
CacheStorage Property
CacheStoragePath Property
ChangesCacheCompressed Property
ChangesCacheStorage Property
ChangesCacheStoragePath Property
MaxCount Property
PoolSize Property
PoolTimeout Property
CompositeDefRelation
Overview
Members
CompositeDefRelation Constructor
CompositeDefRelation Constructor(Diagram,Relation)
CompositeDefRelation Constructor()
Properties
OuterJoinInManyToOne Property
CompositeDefView
Overview
Members
CompositeDefView Constructor
CompositeDefView Constructor(Diagram,Table,C1DataRow)
CompositeDefView Constructor(Diagram,Table)
CompositeDefView Constructor()
Properties
Alias Property
CompositeRelation
Overview
Members
CompositeRelation Constructor
CompositeRelation Constructor(SimpleRelation,Table,Table)
CompositeRelation Constructor(Schema)
CompositeRelation Constructor()
Properties
ChildTableView Property
ParentTableView Property
SimpleRelation Property
CompositeTable
Overview
Members
CompositeTable Constructor
CompositeTable Constructor(Schema,C1DataRow)
CompositeTable Constructor(Schema)
CompositeTable Constructor()
Properties
AllowMultipleConnections Property
CompositeTableDef Property
EffectiveReadOnly Property
CompositeTableDef
Overview
Members
Properties
CompositeTable Property
TableViews Property
ViewRelations Property
CompositeTableField
Overview
Members
CompositeTableField Constructor
CompositeTableField Constructor(CompositeTable)
CompositeTableField Constructor()
Properties
Bound Property
EffectiveReadOnly Property
EffectiveReadOnlyUnlessNew Property
EffectiveUserReadOnly Property
OleDbDataType Property
PrimaryKey Property
TableViewField Property
Connection
Overview
Members
Methods
BeginTransaction Method
Clone Method
Close Method
CommitTransaction Method
Open Method
RollbackTransaction Method
ToString Method
Properties
CommandTimeout Property
ConnectionString Property
ConnectionType Property
DbConnection Property
DbTransaction Property
Description Property
Name Property
Schema Property
SqlInfo Property
ConnectionCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(Connection) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
CustomProviderInfo
Overview
Members
Properties
AssemblyName Property
CommandTypeName Property
ConnectionTypeName Property
DataAdapterTypeName Property
NativeTypeTypeName Property
ParameterNameFormat Property
ParameterNativeTypeProperty Property
ParameterTypeName Property
SqlParameterNameFormat Property
DataSetDef
Overview
Members
DataSetDef Constructor
DataSetDef Constructor(Schema)
DataSetDef Constructor()
Properties
CacheProperties Property
Description Property
FieldDefaults Property
DataSetDefCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(DataSetDef) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
DbTable
Overview
Members
DbTable Constructor
DbTable Constructor(Schema,C1DataRow)
DbTable Constructor(Schema)
DbTable Constructor()
Methods
RetrieveFields Method
Properties
Connection Property
DataMode Property
DbTableName Property
SelectCommandText Property
SelectCommandType Property
DbTableField
Overview
Members
DbTableField Constructor
DbTableField Constructor(Table)
DbTableField Constructor()
Properties
Bound Property
DataSourceReadOnly Property
DbFieldName Property
EffectiveReadOnlyUnlessNew Property
InsertIgnore Property
UpdateIgnore Property
UpdateLocate Property
UpdateRefresh Property
UpdateSet Property
Diagram
Overview
Members
Properties
Name Property
Schema Property
TableViews Property
ViewRelations Property
Field
Overview
Members
Properties
AllowDbNull Property
AutoIncrement Property
AutoIncrementSeed Property
AutoIncrementSequenceName Property
AutoIncrementStep Property
CalculationCondition Property
CalculationExpression Property
CalculationFireEvent Property
Calculations Property
ConstraintCondition Property
ConstraintErrorDescription Property
ConstraintExpression Property
Constraints Property
ConvertEmptyToNull Property
ConvertNullToEmpty Property
DefaultValue Property
Description Property
EffectiveAllowDbNull Property
EffectiveReadOnly Property
EffectiveReadOnlyUnlessNew Property
EffectiveUserReadOnly Property
HasDefaultValueOnServer Property
MaxLength Property
Name Property
NativeDbType Property
Precision Property
PrimaryKey Property
ReadOnly Property
ReadOnlyUnlessNew Property
Scale Property
Type Property
Unique Property
UserReadOnly Property
FieldDefaults
Overview
Members
FieldDefaults Constructor
Properties
ConvertEmptyToNull Property
ConvertNullToEmpty Property
JoinCondition
Overview
Members
JoinCondition Constructor
Properties
ChildField Property
Owner Property
ParentField Property
JoinConditionCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
Insert Method
Remove Method
Properties
Item Property
Relation Property
Relation
Overview
Members
Relation Constructor
Relation Constructor(Schema,Table,Table)
Relation Constructor()
Properties
Cardinality Property
Child Property
Description Property
Name Property
Parent Property
Schema Property
RelationCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(Relation) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
Schema
Overview
Members
Schema Constructor
Methods
Load Method
Load(String) Method
Load(Stream) Method
Save Method
Save(String) Method
Save(Stream) Method
Properties
Connections Property
DataSetDefs Property
Relations Property
Tables Property
SimpleRelation
Overview
Members
SimpleRelation Constructor
SimpleRelation Constructor(Table,Table)
SimpleRelation Constructor(Schema)
SimpleRelation Constructor()
Properties
DeleteCascadeRule Property
EnforceConstraints Property
Joins Property
UpdateCascadeRule Property
UpdateCascadeServer Property
SimpleTable
Overview
Members
SqlDialectInfo
Overview
Members
Properties
AddAsToTableAlias Property
AlwaysEscapeNames Property
Connection Property
DefaultInInsertValues Property
IdentityColumnLastValueSelect Property
IdentityColumnRetrieveMode Property
NameQuote Property
Syntax Property
Table
Overview
Members
Properties
Fields Property
IgnoreDeleteError Property
Name Property
PrimaryKey Property
Schema Property
UpdateLocateMode Property
UpdateRefreshMode Property
TableCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(Table) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
TableField
Overview
Members
Properties
AllowDbNull Property
PrimaryKey Property
Table Property
Unique Property
TableFieldCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(TableField) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
Table Property
TableView
Overview
Members
TableView Constructor
TableView Constructor(Diagram,Table,C1DataRow)
TableView Constructor(Diagram,Table)
TableView Constructor()
Methods
RetrieveFields Method
Properties
AutoEndAddNew Property
DataAccessMode Property
Diagram Property
EffectiveAllowAddNew Property
EffectiveAllowDelete Property
EffectiveReadOnly Property
EffectiveUserReadOnly Property
ExposedInBinding Property
FetchIndex Property
Fields Property
FillIgnore Property
FillSort Property
MemoryResident Property
Name Property
PrimaryKey Property
RowType Property
Table Property
VirtualAsyncThreshold Property
VirtualConsolidateRows Property
VirtualSegmentCount Property
VirtualSegmentSize Property
VirtualSyncThreshold Property
TableViewCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(TableView) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
TableViewField
Overview
Members
TableViewField Constructor
TableViewField Constructor(TableView)
TableViewField Constructor()
Properties
Bound Property
EffectiveReadOnly Property
EffectiveReadOnlyUnlessNew Property
EffectiveUserReadOnly Property
OleDbDataType Property
TableField Property
TableView Property
TableViewFieldCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(TableViewField) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
TableView Property
ViewRelation
Overview
Members
ViewRelation Constructor
ViewRelation Constructor(Diagram,Relation)
ViewRelation Constructor()
Properties
Cardinality Property
Child Property
Description Property
Diagram Property
ExposedInBinding Property
GetRowsEvent Property
Name Property
OneWay Property
Parent Property
Relation Property
ViewRelationCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(String) Method
IndexOf(ViewRelation) Method
Insert Method
Remove Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
Enumerations
AutoIncrementEnum
ConnectionTypeEnum
DataAccessModeEnum
DataModeEnum
FieldUpdateSetModeEnum
IdentityColumnRetrieveModeEnum
ReferentialIntegrityRuleEnum
RelationCardinalityEnum
SqlQuoteEnum
SqlSyntaxEnum
TableUpdateLocateModeEnum
TableUpdateRefreshModeEnum
YesNoDefaultEnum
C1.Data.Express.2 Assembly
Namespaces
C1.Data.Express Namespace
Overview
Classes
C1ExpressConnection
Overview
Members
C1ExpressConnection Constructor
Methods
AcceptChanges Method
Fill Method
GetExportDataSet Method
GetExportDataSet() Method
GetExportDataSet(Boolean) Method
HasChanges Method
HasChanges() Method
HasChanges(DataRowStateEnum) Method
PopExecutionMode Method
PushExecutionMode Method
ReadXml Method
ReadXml(String) Method
ReadXml(Stream) Method
ReadXml(XmlReader) Method
RejectChanges Method
Update Method
WriteXml Method
WriteXml(String) Method
WriteXml(Stream) Method
WriteXml(XmlTextWriter) Method
Properties
AlwaysEscapeNames Property
CaseSensitive Property
ChangeInProgress Property
Connection Property
ConnectionString Property
ConnectionTimeout Property
ConnectionType Property
Database Property
DataSet Property
DataSource Property
DbTables Property
ExecutionMode Property
ExpressTables Property
FieldDefaults Property
FillOnRequest Property
Locale Property
Provider Property
Relations Property
SortComparisonMode Property
Events
AfterFill Event
AfterUpdate Event
AfterUpdateRow Event
BeforeFill Event
BeforeUpdate Event
BeforeUpdateRow Event
Error Event
GetChildRows Event
UpdateError Event
C1ExpressField
Overview
Members
C1ExpressField Constructor
C1ExpressField Constructor()
C1ExpressField Constructor(C1ExpressTable)
Properties
AllowDbNull Property
AutoIncrement Property
AutoIncrementSeed Property
AutoIncrementSequenceName Property
AutoIncrementStep Property
Bound Property
DataSourceReadOnly Property
DbFieldName Property
DbTableName Property
HasDefaultValueOnServer Property
MaxLength Property
Name Property
NativeDbType Property
Precision Property
PrimaryKey Property
ReadOnly Property
ReadOnlyUnlessNew Property
Scale Property
Table Property
Unique Property
UpdateIgnore Property
UpdateLocate Property
UpdateRefresh Property
UpdateSet Property
UserReadOnly Property
C1ExpressFieldCollection
Overview
Members
Methods
Add Method
Contains Method
CopyTo Method
IndexOf Method
IndexOf(C1ExpressField) Method
IndexOf(String) Method
Insert Method
Remove Method
RemoveAt Method
Properties
Item Property
Item(Int32) Property
Item(String) Property
Table Property
C1ExpressJoin
Overview
Members
C1ExpressJoin Constructor
C1ExpressJoin Constructor()
C1ExpressJoin Constructor(C1ExpressJoinCollection)
Properties
ChildFieldName Property
Owner Property
ParentFieldName Property
C1ExpressJoinCollection
Overview
Members
Methods
Add Method
Add(String,String) Method
Add(JoinCondition) Method
Contains Method
CopyTo Method
IndexOf Method
Insert Method
Remove Method
RemoveAt Method
Properties
Item Property
Relation Property
C1ExpressRelation
Overview
Members
C1ExpressRelation Constructor
C1ExpressRelation Constructor()
C1ExpressRelation Constructor(C1ExpressConnection)
Properties
ChildTable Property
ConnectionComponent Property
DeleteRule Property
EnforceConstraints Property
GetRowsEvent Property
Joins Property
MainChildTableName Property
MainParentTableName Property
MasterDetail Property
ParentTable Property
SchemaRelationName Property
UpdateRule Property
C1ExpressRelationCollection
Overview
Members
Methods
Add Method
Add() Method
Add(C1ExpressRelation) Method
Clear Method
Contains Method
CopyTo Method
IndexOf Method
Insert Method
Remove Method
Properties
Item Property
C1ExpressTable
Overview
Members
C1ExpressTable Constructor
Properties
AllowAddNew Property
AllowDelete Property
ConnectionComponent Property
ConnectionString Property
ConnectionTimeout Property
ConnectionType Property
DataAccessMode Property
DataAdapter Property
Database Property
DataSource Property
DbTableName Property
ExpressConnection Property
Fields Property
FillFilter Property
FillOnRequest Property
FillSort Property
Provider Property
ReadOnly Property
SelectCommandText Property
SelectCommandType Property
TableName Property
UserReadOnly Property
Events
AfterFill Event
AfterGenerateSql Event
AfterUpdateRow Event
BeforeFill Event
BeforeGenerateSql Event
BeforeUpdateRow Event
UpdateError Event
C1ExpressView
Overview
Members
C1ExpressView Constructor
Properties
ExpressTable Property
ExpressTableName Property
ExpressGenerateSqlEventArgs
Overview
Members
Properties
TableName Property
Delegates
ExpressGenerateSqlEventHandler