public void EnumField_Query_ESql_Param()
{
var entity = new EnumFieldEntity {
Value = EnumFieldType.EnumValue1
};
this.context.EnumFieldEntities.Add(entity);
this.context.SaveChanges();
var adapter = this.context as IObjectContextAdapter;
var objectContext = adapter.ObjectContext;
var sql = "SELECT VALUE t.Id FROM EnumFieldEntities as t WHERE t.Value == @Value";
var parameters =
new ObjectParameter[] {
new ObjectParameter("Value", EnumFieldType.EnumValue1)
};
var queried = objectContext
.CreateQuery <object>(sql, parameters)
.FirstOrDefault();
queried.Should().NotBeNull();
queried.Should().Be(entity.Id);
}
public void EnumField_Delete()
{
var entity = new EnumFieldEntity {
Value = EnumFieldType.EnumValue1
};
this.context.EnumFieldEntities.Add(entity);
this.context.SaveChanges();
this.context.EnumFieldEntities.Remove(entity);
this.context.SaveChanges();
}
