public void WhereWithEqualWithParameterName() { var expected = new Query <NonRelationEntity>(where : new EqualOperator(new Property <NonRelationEntity>(nameof(NonRelationEntity.Id)), new Parameter("Id"))); var actual = Lt.Query <NonRelationEntity>().Where(_ => _.Id == Lt.Arg <int>("Id")).ToImmutable(); Assert.Equal(expected, actual); }
public void Setup() { _container = new Container(); _dbConnection = new SqlConnectionFactory().Create(); new global::LtQuery.ORM.DryIoc.Module().Register(_container); var tableRegistrator = _container.Resolve <global::LtQuery.ORM.ITableDefinitionRegistrator>(); tableRegistrator.Register(() => new Tables.TestEntityDefinition()); var resolver = _container.Resolve <global::LtQuery.ORM.ITableDefinitionResolver>(); var sqlBuilder = new SqlServerSqlBuilder(resolver); _connection = new LtConnection(resolver, sqlBuilder, _dbConnection); _query = Lt.Query <TestEntity>().ToImmutable(); _singleQuery = Lt.Query <TestEntity>().Where(_ => _.Id == Lt.Arg <int>()).ToImmutable(); _connection.Select(_query); _connection.Single(_singleQuery, new { Id = 1 }); }
public int LtQuery() { var accum = 0; using (var container = new Container()) { new global::LtQuery.ORM.DryIoc.Module().Register(container); var tableRegistrator = container.Resolve <global::LtQuery.ORM.ITableDefinitionRegistrator>(); tableRegistrator.Register(() => new LtQuery.Tables.TestEntityDefinition()); var tableResolver = container.Resolve <global::LtQuery.ORM.ITableDefinitionResolver>(); var sqlBuilder = new SqlServerSqlBuilder(tableResolver); using (var dbConnection = new SqlConnectionFactory().Create()) using (var connection = new LtConnection(tableResolver, sqlBuilder, dbConnection)) { var singleQuery = Lt.Query <TestEntity>().Where(_ => _.Id == Lt.Arg <int>()).ToImmutable(); var entity = connection.Single(singleQuery, new { Id = 1 }); AddHashCode(ref accum, entity.Id); } return(accum); } }