Need SqlAnywhereAdapter or SybaseAdapter
Opened this issue · 0 comments
Hello, i'm using actually Dapper for Sybase (SQL Anywhere) for QueryFirstOrDefault, Query, Execute and ExecuteScalar and it is pretty well supported actually.
I use it as follow with the parameter [ ?property? ] instead of [@Property]":
string sql = "select * from Order where Order_ID = ?Order_ID?"
var order = conn.Query(sql, new { Order_ID= 3 });
as simple like that.
but Actually I cannot use the Dapper.Contrib functions => Insert, update, delete, etc.. because it is hardcoded with the SQLServer parameter @Order_ID by default.
I'm suggesting to add a SqlAnywhereAdapter to the SqlMapperExtension.cs
I want to tell you also that Access 2000 seems to works with single [ ? ] parameter as well when connected by OleDb (Insert into ... (?,?,?'?), new { value1, value2, value3, value4 };
Also, Access DB have difficulty with DateTime type and want it to be in string format before inserting.
[ DateTime.Today.ToString("yyyy-MM-dd") ]
Thank you for feedbacks.