private void button3_Click(object sender, EventArgs e)
{
using (ZhangDasiDBEntities dbCntxt = new ZhangDasiDBEntities())
{
//dbCntxt.Configuration.ProxyCreationEnabled = false;
var tenant = dbCntxt.Tenant.Include("CarTenant.Car")
.Where(t => t.TenantID == 2)
.Select("tt => new { tt.Name, tt.CarTenant.Select(t => new { t.CarID }) as CT }").ToDynamicList();
/*.Select(
* tt => new { tt.Name, ct = tt.CarTenant.Select(t => new { t.CarID }) }).FirstOrDefault();
*/
foreach (var t in tenant)
{
Console.WriteLine(t.Name);
foreach (var c in t.CT)
{
Console.WriteLine(c.CarID);
}
}
string jsonString;
jsonString = JsonSerializer.Serialize(tenant);
Console.WriteLine(jsonString);
}
}
private void button2_Click(object sender, EventArgs e)
{
using (ZhangDasiDBEntities dbCntxt = new ZhangDasiDBEntities())
{
//dbCntxt.Configuration.ProxyCreationEnabled = false;
var tenant = dbCntxt.CarTenant.Include("Car").Include("Tenant");
var converter = new CriteriaToEFExpressionConverter();
var l = tenant.AppendWhere(converter, CriteriaOperator.Parse("Contains([Car.Vendor],'E')")).Cast <CarTenant>();
foreach (var c in l)
{
Console.WriteLine(c.CarID + " " + c.Car.Vendor + " " + c.Car.Price + " " + c.Tenant.Name);
}
}
}
