public void CannotMapReference()
{
var convention = new DefaultConvention();
var studentBuilder = new EntityMapBuilder<Student>(convention);
var stuMap = ((EntityMapBuilder<Student>)studentBuilder
.Reference(_=>_.Course, "Course_id"))
.Build();
studentBuilder.BuildReferences(new[] {stuMap});
}
public void CanMapReference()
{
var convention = new DefaultConvention();
var studentBuilder = new EntityMapBuilder<Student>(convention);
var courseBuilder = new EntityMapBuilder<Course>(convention);
var stuMap = studentBuilder.Build();
var crsMap = courseBuilder.Build();
studentBuilder.BuildReferences(new[] {crsMap, stuMap});
Assert.IsNotNull("[Course_id]", stuMap.References[0].Column.Value);
}
public void CanGetDefaultMap()
{
var convention = new DefaultConvention();
var builder = new EntityMapBuilder<Student>(convention);
var map = builder.Build();
Assert.IsNotNull(map);
Assert.AreEqual("[Student]", map.Table.Value);
Assert.AreEqual("[dbo]", map.Schema.Value);
Assert.AreEqual("[Student_id]", map.Key.Column.Value);
Assert.AreEqual("[Name]", map.Properties[1].Column.Value);
}
public void CanSetEntityMapping()
{
var convention = new DefaultConvention();
var builder = new EntityMapBuilder<Student>(convention);
var map = ((EntityMapBuilder<Student>)builder.Table("Students")
.Schema("DBO")
.Key(_ => _.Student_id, "ID")
.Property(_ => _.Name, "StudentName"))
.Build();
Assert.AreEqual("[Students]", map.Table.Value);
Assert.AreEqual("[DBO]", map.Schema.Value);
Assert.AreEqual("[ID]", map.Key.Column.Value);
Assert.AreEqual("[StudentName]", map.Properties[1].Column.Value);
}
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;
}
