public virtual TType DoScaler <TType>(string query, object parameters, Func <TType, bool> resultAction = null)
{
query = _queryGenerator.Query(query, parameters, out IList <QueryInfo> queryParameters);
var cmd = new DotEntityDbCommand(DbOperationType.SelectScaler, query, queryParameters, commandBehavior: CommandBehavior.SingleRow);
DotEntityDbConnector.ExecuteCommand(cmd);
return(cmd.GetResultAs <TType>());
}
public void QueryGenerator_ManualSelect_Valid()
{
var expected = "SELECT * FROM `Product` WHERE `Id`=@Id AND `IsActive`=@IsActive;";
var sql = generator.Query(expected, new { Id = 5, IsActive = false }, out IList <QueryInfo> queryParameters);
Assert.AreEqual(expected, sql);
Assert.AreEqual(5, queryParameters.First(x => x.ParameterName == "Id").PropertyValue);
Assert.AreEqual(false, queryParameters.First(x => x.ParameterName == "IsActive").PropertyValue);
}
