Question

T-SQL

USE [AdventureWorks];
SELECT p.* FROM Production.ProductCategory cat ,[Production].[ProductSubcategory] sub, [Production].[Product] p
WHERE cat.ProductCategoryID=1 AND sub.ProductCategoryID = cat.ProductCategoryID and p.ProductSubcategoryID = sub.ProductSubcategoryID

并且想将实体数据库转换成电子SQL

<asp:EntityDataSource ID="ProductDataSource" runat="server"  ConnectionString="name=AdventureWorksEntities" 
    DefaultContainerName="AdventureWorksEntities"  EntitySetName="Product" 
    Where="EXISTS(SELECT VALUE cat FROM ProductCategory AS cat WHERE cat.ProductCategoryID=1) 
             AND EXISTS(SELECT VALUE sub FROM ProductSubcategory AS sub WHERE sub.ProductCategoryID = cat.ProductCategoryID) 
             AND it.ProductSubcategoryID = sub.ProductSubcategoryID) " 
    >
</asp:EntityDataSource>

但这是错误的。

Update : Thanks devart hints, I modify the query to

SELECT VALUE p FROM AdventureWorksEntities.ProductCategory AS cat, AdventureWorksEntities.ProductSubcategory AS sub, AdventureWorksEntities.Product AS p WHERE cat.ProductCategoryID=1 AND sub.ProductCategoryID = cat.ProductCategoryID and p.ProductSubcategoryID = sub.ProductSubcategoryID

它现在工作。

Answer 1

你们可以使用以下标准选择实体目录活动手,例如:

string query = @"SELECT VALUE p FROM EntityContainer.ProductCategory as cat, EntityContainer.ProductSubcategory as sub, EntityContainer.Product as p WHERE cat.ProductCategoryID=1 AND sub.ProductCategoryID = cat.ProductCategoryID and p.ProductSubcategoryID = sub.ProductSubcategoryID";
EntityDataSource source = null; 
source = Page.FindControl("ProductDataSource") as EntityDataSource;
if(source != null) {
  source.EntitySetName = null;
  source.CommandText = query;
}

该法典规定了一种强烈的分类结果,并使用了该条款。

友情链接