删除的方法如下:
await _connection.DeleteListAsync<EFCore.Entity.Demo>(" where id in(@ids)", new {ids =new string[]{"1","2"}});
生成的sql 语句类似:delete from demo where id in('1','2')
mysql 5.7
直接执行上述sql 也报错,有知道原因的吗
方言问题,默认是sql server
报错:对象名 'demo' 无效?
不是,类似:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[u_info] where id in(('49f44bc3-01f7-4081-aa5c-64b28035ef3e'))' at line 1
再查询编辑器里面直接执行:delete from u_info where id in(('49f44bc3-01f7-4081-aa5c-64b28035ef3e')) ,也不行