LINQtoEntities多连接你好我正在尝试复制这个mysql查询SELECTa.id,a.title,a.description,a.categories_id,c.name,d.titleFROMadsASaINNERJOINlocationsASbONa.locations_id=b.idINNERJOINareasAScONb.areas_id=c.idINNERJOINcategoriesASdONa.categories_id=d.id哪里a.titleLIKE'%mini%'ANDc.name='Fyn'LIMIT10这是在LINQvarquery=(fromaindb.adsjoinbindb.locationsona.locations_idequalsb.idjoincindb.areasonb.id等于c.idjoindindb.categoriesona.categories_idequalsd.idwherea.title.Contains(searchQuery)&&c.name.Equals(area)selectnew{a.id,a.title,a.description,category=d.title}).Take(10);它不显示任何错误,但不返回任何数据。你第三行报错:joincindb.areasonb.idequalsc.id以上应该就是C#学习教程:LINQtoEntitiessharedbymultipleconnections的全部内容,如果对大家有用的话并且需要了解更多C#学习教程,希望大家多多关注——joincindb.areasonb.areas_idequalsc.id本文收集自网络,不代表立场。如涉及侵权,请点击右侧联系管理员删除。如需转载请注明出处:
