Insert in SqlCE

[tmsmith]

Insert in SqlCE

[tmsmith]

The latest version of DapperExtensions does not batch SqlCE statements, but rather makes 2 calls similar to your post.

if (_sqlGenerator.RunInsertAsBatch()) // SqlCeDialect returns false
{
result = connection.Query(sql, entity, transaction, false, commandTimeout, CommandType.Text);
}
else
{
connection.Execute(sql, entity, transaction, commandTimeout, CommandType.Text);
sql = _sqlGenerator.IdentitySql(classMap);
result = connection.Query(sql, entity, transaction, false, commandTimeout, CommandType.Text);
}