public SelectPaging(BracketedName alias, Select innerSelect, IValueProvider skip) { innerSelect.Columns.AddRowNumber(innerSelect.OrderBy); innerSelect.OrderBy = null; _skip = skip; _innerSelect = innerSelect; _alias = alias; }
public WhereConverter(Select select, QueryContext context) { if (select == null) throw new ArgumentNullException("select"); if (context == null) throw new ArgumentNullException("context"); _select = select; _context = context; }
public void CanRenderSelect() { var writer = new SqlWriter(); var convention = new DefaultConvention(); var builder = new EntityMapBuilder<Student>(convention); var map = ((EntityMapBuilder<Student>) builder .Key(_ => _.ID, "Student_id")).Build(); var selectEntity = new Select(map, "t0"); selectEntity.Render(writer); var result = writer.GetResult(); AssertHelper.AreEqualWithNoSpaces( @"SELECT [t0].[Student_id], [t0].[Name] FROM [dbo].[Student] AS [t0] (NOLOCK)", result); }
public From(Select select) { _select = select; }
private ISqlNode VisitRoot(ISqlNode parent, Expression expr) { var select = new Select(_context); return select; }
static string GetWhere(Expression<Func<Student, bool>> expr) { var convention = new DefaultConvention(); var builder = new EntityMapBuilder<Student>(convention); var map = ((EntityMapBuilder<Student>)builder .Key(_ => _.ID, "Student_id")) .Build(); var context = new QueryContext(new[]{map}, ""); var selectEntity = new Select(map, "t0"); var whereParser = new WhereConverter(selectEntity, context); var node = whereParser.Visit(expr); node.Render(context.Writer); var result = context.Writer.GetResult(); return result; }