search

tmsmith / Dapper-Extensions

Dapper Extensions is a small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system. The goal of this library is to keep your POCOs pure by not requiring any attributes or base class inheritance.
1.79k stars 584 forks source link

sql error #285

Closed xtxk110 closed 2 years ago

xtxk110 commented 2 years ago

The generated MySQL statement contains [], and an error is reported during execution. Please try to use instead

ALMMa commented 2 years ago

@xtxk110 I believe you should set the SQL dialect that DapperExtensions will use.

DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.MySqlDialect();

If you already set the dialect, then it's likely a duplicate of https://github.com/tmsmith/Dapper-Extensions/issues/273

xtxk110 commented 2 years ago

@xtxk110 I believe you should set the SQL dialect that DapperExtensions will use.

DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.MySqlDialect();

If you already set the dialect, then it's likely a duplicate of #273

have already been solved，thanks