History

Commits on master to Source/Libraries/GSF.Core/Data/Model/TableOperations.cs35+

GSF.Data: Added static GetTableName function to table operations, which returns name described by model attributes.Billy Ernest committed 5 years ago1ecb397
GSF.Data: Added ConfigFileTableNamePrefixAttribute which allows the use of a general prefix to the table name that can be set in the config file.Billy Ernest committed 5 years agoa01591e
GSF.Core: Added more resharper message suppression for TableOperations.J. Ritchie Carroll committed 6 years ago432227a
GSF.Core: Updated TableOperations to properly handle modeled "char" properties when posting SQL updates to SQLite.J. Ritchie Carroll committed 7 years ago9780b69
GSF: Cleared warnings from recent code check-ins.J. Ritchie Carroll committed 7 years ago1d81928
GS.Core: Updated TableOperations comments for clarity.J. Ritchie Carroll committed 8 years ago720545e
GSF.Core: Updated TableOperations comments related to ApplyRootQueryRestrictionToUpdates and ApplyRootQueryRestrictionToDeletes properties.J. Ritchie Carroll committed 8 years ago3b00a46
GSF.Core: Added ApplyToUpdates and ApplyToDeletes properties to the RootQueryRestrictionAttribute so that application to target operations can apply automatically through modeling.J. Ritchie Carroll committed 8 years ago86a478c
GSF.Core: Updated TableOperations Update function to apply RootQueryRestrictions earlier in function so that root restriction is applied even if user does not provide an additional one.J. Ritchie Carroll committed 8 years ago9e131ba
GSF.Core: Updated TableOperations to include ability to control if root record restrictions should be applied to update and delete operations.J. Ritchie Carroll committed 8 years ago350752b
GSF.Core: Updated comments in TableOperations related to root query restrictions.J. Ritchie Carroll committed 8 years ago90b09d6
GSF.Core: Added code to handle use case when string based primary keys could be marked for encryption.J. Ritchie Carroll committed 8 years ago93fa655
GSF.Core: Updated paginated QueryRecords with specified sort field to operate properly even when sort field is encrypted.J. Ritchie Carroll committed 8 years agodfa9fd5
GSF.Core: Updated TableOperations to use local Linq sort when specified sort field has been marked for encryption.J. Ritchie Carroll committed 8 years ago960b42c
GSF.Core: Added "SearchRecords" function to TableOperations to allow local searches against retrieved table records as queried from database for fields modeled with SearchableAttribute, this way search functionality will work even with fields that are modeled with the EncryptDataAttribute and use the SearchType.LikeExpression.J. Ritchie Carroll committed 8 years ago2e77817
GSF.Core: Improved comments related to TableOperations.J. Ritchie Carroll committed 8 years ago71cc31e
GSF.Core: Changed TableOperations encrypted search targets to a list since order matters when constructing a search stringJ. Ritchie Carroll committed 8 years agob50c6bf
GSF.Core: Added TableOperation handling for use case where a field is modeled as both searchable and encrypted.J. Ritchie Carroll committed 8 years ago84d9577
GSF.Core: Updated GetInterpretedValue in TableOperations to handle cases where with encrypted data targets or field data type targets could be null.J. Ritchie Carroll committed 8 years agod310cc9
GSF.Core: Added ability to encrypt and decrypt data models with TableOperations using an EncryptDataAttribute.J. Ritchie Carroll committed 8 years agoba9e31a
GSF.Core: Updated TableOperations to apply any defined escaped field name targets to default order by expression.J. Ritchie Carroll committed 8 years ago6b020fe
GSF.Core: Updated documentation in table operations.J. Ritchie Carroll committed 9 years ago5ddc39f
GSF.Core: Added a way to get a value in table operations if a property exists in the model but is not in the database.Billy Ernest committed 9 years ago3ea8450
GSF.Core: Added method to TableOperations to convert a collection of records to a DataTable.StephenCWills committed 9 years ago1a2c055
GSF.Core: Improved code comments related to field data type attribute application.J. Ritchie Carroll committed 9 years agoca64546
GSF.Core: Optimized internal GetInterpretedPropertyValueJ. Ritchie Carroll committed 9 years ago3af31a8
GSF.Core: Updated code comments for record restriction parameters and GetInterpretedFieldValue to better clarify use case for when function will need to be called.J. Ritchie Carroll committed 9 years agof6aca67
GSF.Core: Added FieldDataTypeAttribute to GSF.Data.Model to allow for specific DbType to be applied to parameter fields for database operations (e.g., DateTime2 for SQL Server) - attribute allows for specific database targets in model, e.g., [FieldDataType(DbType.DateTime2, DatabaseType.SQLServer)]J. Ritchie Carroll committed 9 years agoca0e4af
GSF.Core: Cleared code analysis messages.J. Ritchie Carroll committed 9 years ago2e52236
GSF.Core: Added static delegates for helpful modeled record functions that can be used when no data connection is available: LoadRecordFunction, NewRecordFunction, ApplyRecordDefaultsFunction and ApplyRecordUpdatesFunction.J. Ritchie Carroll committed 9 years agoa4fb9f4
GSF.Core: Updated AdoDataConnection to not modify parameter array contents that get passed into function that accept parameterized queries.J. Ritchie Carroll committed 9 years agocbc8ac2
GSF.Core: Updated per table operation instance root query restriction to be a clone of static instance to better support non-conflicting updates to parameter array, if needed.J. Ritchie Carroll committed 9 years ago4204259
GSF.Core: Updated TableOperations root query restriction operations to clone the cached record restriction before use since the AdoDataConnection functions that accept parameters auto-convert the parameters into IDbDataParameter instances tied to a specific IDbCommand making any record restriction non-reusable.J. Ritchie Carroll committed 9 years agoc0c4c0d
GSF.Core: Added RootQueryRestrictionAttribute to allow global query filters that should apply to all query operations.J. Ritchie Carroll committed 9 years ago8e9550b
GSF.Core: (1) Added a delegate generator for "ApplyDefaults" to ValueExpressionParser that can be used to apply defaults to an existing modeled object, (2) Added "ApplyRecordDefaults" to TableOperations such that default values and expressions can be applied to an existing modeled record.J. Ritchie Carroll committed 9 years ago5ab8463