public int Create(T obj)
{
var query = _dapperQueryBuilder.CreateQuery(obj);
var result = this._mysqlConnection.ExecuteScalar(query);
_logger.Information("{source} {template} {dbquery} {dbqueryresult}", "repository", typeof(T).Name, query, result);
return(Convert.ToInt32(result));
}
//[Test]
public void CreateQueryShouldReturnInsertIntoStatement()
{
// Given
var entity = new SampleEntity()
{
sampleInt = 1,
sampleStr = "str",
sampleBool = true,
sampleDateTime = DateTime.Now
};
var dapperQueryBuilder = new DapperQueryBuilder <SampleEntity>();
// When
var query = dapperQueryBuilder.CreateQuery(entity);
// Then
Assert.AreEqual($"insert into samples(sampleint, samplestr, samplebool, sampledatetime, guid, isactive, isdeleted, createdat, createduserid, updatedat, updateduserid) values(1, 'str', True, '{DateTime.Now}', False, False, '{DateTime.Now}', 0, '{DateTime.Now}', 0) returning id", query);
}
