All notable changes to this project will be documented in this file. The format is based on Keep a Changelog,
2.0.28 - 2020-08-07
- Oracle support
2.0.0 - 2019-08-24
- MySQL support
- Support for ReadOnly attribute. This allows for you to create insert sql from an object but ignore a specified property. for insert sql creation only. You would want this when you have a default value for a column in your table schema and you want to use that default value instead of the .net property value.
- Affect method BuildDBParameters . ConvertToDatabaseValue will no longer auto-convert value of DateTime.MinValue that belongs to a DateTime type property to sqlserver DateTime minimum supported value of 01,01,1753 see https://stackoverflow.com/a/12364243/2445462
object ConvertToDatabaseValue(MemberWrapper member, object value, Func<object, string> XmlSerializer, Func<object, string> JsonSerializer, Func<object, string> CsvSerializer)
- (BREAKING CHANGE) removed the following api from ObjectToSql
object ConvertToDatabaseValue(object value)
1.0.94 - 2019-08-22
- The following overload now support anonymous object insert statement
string BuildQuery<T>(ActionType actionType, string tableName = null) where T : class
1.0.93 - 2019-08-21
- removed primary keys from being set when creating update statements. This will allow support for anonymous object to be inserted into a table have identity keys
1.0.91 - 2019-08-20
- Overload now supports update,upsert,delete action type for anonymous types
public string BuildQuery<T>(ActionType actionType, string tableName = null, params Expression<Func<T, object>>[] primaryKeys) where T : class
1.0.89 - 2019-08-17
- BREAKING CHANGES
- Re-Order tableName parameter to the end of all public methods in ObjectToSql
// OLD API
public string BuildQuery(string tableName, ActionType actionType, object instance)
// NEW API
public string BuildQuery( ActionType actionType, object instance,string tableName)
1.0.62 - 2019-07-21
- Overload now supports insert action type for dynamic and anonymous types
public string BuildQuery(string tableName, ActionType actionType, object instance)
1.0.59 - 2019-07-20
- fix bug where mapped column name was being used instead of property name in upsert sql only for sqlite targeting .
1.0.57 - 2019-07-20
- Fix bug in upsert statement generatation for sqlite.