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