Protected Static Properties
  DBNull | Returns a cached reference to DBNull |
Public Instance Constructors
EasyObject Constructor
|
The default constructor. |
Public Instance Fields
 StringFormat | A format string used for displaying date values |
Public Instance Properties
 ConnectionDatabase | Gets or sets the database to connect to |
| ConnectionPassword | Gets or sets the password to use in the connect string for the database |
| ConnectionServer | Gets or sets the database server to connect to |
| ConnectionString | Gets or sets the connection string used to connect to the database. |
| ConnectionUserID | Gets or sets the user ID to use in the connect string for the database |
| DatabaseInstanceName | Gets or sets the database instance name from the dataConfiguration.config file used to load the EasyObject. |
| DBProviderType | Gets or sets the DBProviderType to use when creating dynamic connection strings |
| DefaultCommandType | Determines what CommandType will be used by default. |
| DefaultView | Returns a reference to the EasyObjects DefaultView. |
| DynamicQueryInstanceName | Gets or set the dynamic query instance name from the dynamicQuerySettings.config file used to build dynamic queries. |
| ErrorCode | Gets or sets the internal error code. |
| ErrorMessage | Gets or sets the internal error message. |
| Filter | After loading your EasyObject you can filter (temporarily hide) rows. To disable the filter set this property to String.empty. After applying a filter, using Iteration via MoveNext will properly respect any filter you have in place. See also Sort. |
| IdentityInsert | Allows for inserting primary key values that are normally autogenerated by the database Note This may not be support for all database providers |
| Query | Returns a reference to the EasyObject's DynamicQuery object. |
| QuerySource | Used to set an alternate query source (such as a view) when building dynamic queries. |
| RowCount | Returns the number of rows stored in the EasyObject |
| SchemaEntries | Gets or sets a reference to the SchemaEntries for the EasyObject. |
| SchemaGlobal | Setting this is a quick way to set both SchemaTableView and SchemaStoredProcedure. at the same time. Setting this property does nothing more than assign both SchemaTableView and SchemaStoredProcedure, very rarely will you need to set SchemaTableView to one schema and SchemaStoredProcedure to a different schema. |
| SchemaSeparator | Gets the string separator used between the schema and database object. |
| SchemaStoredProcedure | This is the schema for the stored procedures that will be accessed by the EasyObject. For instance, if you set this to "HR" then when you do an update your stored procedure will be prefaced by "HR.MyStoredProc" See SchemaGlobal. |
| SchemaStoredProcedureWithSeparator | This is the schema for the stored procedures that will be accessed by the EasyObject. For instance, if you set this to "HR" then when you do an update your stored procedure will be prefaced by "HR.MyStoredProc" See SchemaGlobal. |
| SchemaTableView | This is the schema for the Table or View that will be accessed via Query.Load() and AddNew(). For instance, if you set this to "HR" then Query.Load() will use "HR.EMPLOYEES" instead of just "EMPLOYEES". See SchemaGlobal. |
| SchemaTableViewWithSeparator | This is the schema for the Table or View that will be accessed via Query.Load() and AddNew(). For instance, if you set this to "HR" then Query.Load() will use "HR.EMPLOYEES" instead of just "EMPLOYEES". See SchemaGlobal. |
| Sort | Gets or sets the sort column for the EasyObject. |
| TableName | Returns the name of database table used to define the EasyObject. |
| UseIntegratedSecurity | Gets or sets the flag to use Integrated Security when connecting to the database |
Public Instance Methods
| AcceptChanges | Commits all the changes in the internal DataTable since the last time AcceptChanges was called. |
| AddColumn | After loading your BusinessEntity you can add custom columns, this is typically done to create a calculated column, however, it can be used to add a column just to hold state, it will not be saved to the database of course. |
| AddNew | Adds a new row to the internal DataTable. |
| DeleteAll | Marks every row in the internal DataTable as deleted. |
| Deserialize | Reload an EasyObject from a previous call to Serialize. |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| FlushData | Resets the EasyObject to an empty state. |
| FromXml | Overloaded. Reload the EasyObject from a previous call to ToXml. Use the mode parameter for finer control. |
| GetChanges | Overloaded. Gets a copy of internal DataTable containing all the changes to it since it was last loaded, or since AcceptChanges was last called. |
| GetColumn | This is the typeless version, this method should only be used for columns that you added via AddColumn or to access extra columns brought back by changing your QuerySource to a SQL View. |
| GetDatabase | Get the database defined in the configuration file. |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
| GetItemString | Overloaded. Retrieves the string value of the SchemaItem |
| GetProperties | Retrieves the list of the object's properties using reflection and returns them in an array |
| GetPropertyByNamedValue | Retrieves the value of a property using the name via reflection |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| IsColumnNull | Checks if a particular column in the EasyObject has a null value. |
| Load | Overloaded. Loads the internal DataTable with the named table in a DataSet. |
| MarkAsDeleted | Marks the current row in the internal DataTable as deleted. |
| MoveNext | Moves the current row of internal DataTable. |
| RejectChanges | Rolls back the internal DataTable to the state is was in when it was loaded, or the last time AcceptChanges was called. |
| Rewind | Resets the internal DataTable to the first row. |
| RowState | Gets the current state of the current row in the internal DataTable. |
| Save | Overloaded. Overload to save with a default |
| Serialize | This method will allow you to save the contents of the EasyObject to XML. It is saved as a DataSet with Schema, data, and Rowstate as a DiffGram. You can load this data into another entity of the same type via Deserialize. Call GetChanges before calling Serialize to serialize only the modified data. |
| SetColumn | This is the typeless version, this method should only be used for columns that you added via AddColumn or to access extra columns brought back by changing your QuerySource to a SQL View. |
| SetColumnNull | Use this method to set a column to DBNull.Value which will translate to NULL in your DBMS system. |
| SetItem | Sets the value for a SchemaItem in the internal DataTable. |
| SetProperty | Sets a property value using the property name via reflection |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
| ToXml | Overloaded. This method will allow you to save the contents of the EasyObject to XML. You can load this data into another EasyObject of the same type via FromXml. Call GetChanges before calling ToXml to serialize only the modified data. |
Protected Instance Properties
| DataRow | Returns a reference to the current row of the EasyObject. |
| Transaction | Gets or sets a reference to the current EasyObject transaction. Note This is primarily used internally. |
Protected Instance Methods
 Finalize (inherited from Object) | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. |
| GetBoolAsString | Used by the String Properties in your generated class. |
| GetBoolean | Used by the Properties in your generated class. |
| GetBooleanAsString | Used by the String Properties in your generated class. |
| GetByte | Used by the Properties in your generated class. |
| GetByteArray | Used by the Properties in your generated class. |
| GetByteAsString | Used by the String Properties in your generated class. |
| GetDateTime | Used by the Properties in your generated class. |
| GetDateTimeAsString | Used by the String Properties in your generated class. |
| GetDecimal | Used by the Properties in your generated class. |
| GetDecimalAsString | Used by the String Properties in your generated class. |
| GetDeleteCommand | Overloaded. Used by derived classes |
| GetDouble | Used by the Properties in your generated class. |
| GetDoubleAsString | Used by the String Properties in your generated class. |
| GetFloat | Used by the Properties in your generated class. |
| GetFloatAsString | Used by the String Properties in your generated class. |
| GetGuid | Used by the Properties in your generated class. |
| GetGuidAsString | Used by the String Properties in your generated class. |
| GetInsertCommand | Overloaded. Used by derived classes |
| GetInt32 | Used by the Properties in your generated class. |
| GetIntAsString | Used by the String Properties in your generated class. |
| GetInteger | Used by the Properties in your generated class. |
| GetIntegerAsString | Used by the String Properties in your generated class. |
| GetLong | Used by the Properties in your generated class. |
| GetLongAsString | Used by the String Properties in your generated class. |
| GetObject | Used by the Properties in your generated class. |
| GetShort | Used by the Properties in your generated class. |
| GetShortAsString | Used by the String Properties in your generated class. |
| GetSingle | Used by the Properties in your generated class. |
| GetSingleAsString | Used by the String Properties in your generated class. |
| GetString | Used by the Properties in your generated class. |
| GetStringAsString | Used by the String Properties in your generated class. |
| GetTimeSpan | Used by the Properties in your generated class. |
| GetTimeSpanAsString | Used by the String Properties in your generated class. |
| GetUpdateCommand | Overloaded. Used by derived classes |
| LoadFromSql | Overloaded. Load the EasyObject with the results from a SQL query or stored procedure. |
| LoadFromSqlNoExec | Overloaded. Execute a SQL query or stored procedure without affecting the EasyObject. |
| LoadFromSqlReader | Overloaded. Return an IDataReader from a SQL query or stored procedure without affecting the EasyObject. |
| LoadFromSqlScalar | Overloaded. Return a value from a SQL query or stored procedure without affecting the EasyObject. |
| LSet | Mimics the old VB LSet function, which places a value within a padded string of a defined length. |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
| PostSave | Perform any operations to the EasyObject after saving. |
| PreSave | Perform any operations to the EasyObject before saving. |
| RSet | Mimics the old VB RSet function, which places a value within a padded string of a defined length. |
| SetBoolAsString | Used by the String Properties in your generated class. |
| SetBoolean | Used by the Properties in your generated class |
| SetBooleanAsString | Used by the String Properties in your generated class. |
| SetByte | Used by the Properties in your generated class |
| SetByteArray | Used by the Properties in your generated class |
| SetByteAsString | Used by the String Properties in your generated class. |
| SetDateTime | Used by the Properties in your generated class |
| SetDateTimeAsString | Used by the String Properties in your generated class. |
| SetDecimal | Used by the Properties in your generated class |
| SetDecimalAsString | Used by the String Properties in your generated class. |
| SetDouble | Used by the Properties in your generated class |
| SetDoubleAsString | Used by the String Properties in your generated class. |
| SetFloat | Used by the Properties in your generated class |
| SetFloatAsString | Used by the String Properties in your generated class. |
| SetGuid | Used by the Properties in your generated class |
| SetGuidAsString | Used by the String Properties in your generated class. |
| SetInt32 | Used by the Properties in your generated class |
| SetIntAsString | Used by the String Properties in your generated class. |
| SetInteger | Used by the Properties in your generated class |
| SetIntegerAsString | Used by the String Properties in your generated class. |
| SetLong | Used by the Properties in your generated class |
| SetLongAsString | Used by the String Properties in your generated class. |
| SetObject | Used by the Properties in your generated class |
| SetShort | Used by the Properties in your generated class |
| SetShortAsString | Used by the String Properties in your generated class. |
| SetSingle | Used by the Properties in your generated class |
| SetSingleAsString | Used by the String Properties in your generated class. |
| SetString | Overloaded. Used by the Properties in your generated class |
| SetStringAsString | Used by the String Properties in your generated class. |
| SetTimeSpan | Used by the Properties in your generated class |
| SetTimeSpanAsString | Used by the String Properties in your generated class. |
Protected Internal Instance Properties
 DataTable | Returns a reference to the current DataTable for the EasyObject. |
See Also
EasyObject Class | NCI.EasyObjects Namespace