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); }