EntityDataSource，选择* From？

Question

例如,

    <asp:EntityDataSource ID="edsPatient" runat="server" 
        ConnectionString="name=ReferralDBEntities" 
        DefaultContainerName="ReferralDBEntities" EnableFlattening="False" 
        EntitySetName="Patients" 
        Select="it, (it.FirstName + it.LastName) as FullName"

        >

但不执行SQL：

Select p.*, (p.FirstName + p.LastName) as FullName from Patients p

是不是EntityDataSource不支持通配符？

Answer 1

<asp:TemplateField HeaderText="CoachName" SortExpression="FullName">
<ItemTemplate>
<asp:DropDownList ID="DDLPeopleID" runat="server"  CssClass="dropdown"
DataSourceID="PeopleEntityDS" DataTextField="FullName"  AppendDataBoundItems="true"
DataValueField="PeopleID"   SelectedValue='<%# Bind("CoachID") %>'>
<asp:ListItem Text="" value=""></asp:ListItem> </asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>

   <asp:EntityDataSource ID="PeopleEntityDS" runat="server" 
        ConnectionString="name=EQnetTableEntities" 
        DefaultContainerName="EQnetTableEntities" 
        EntitySetName="People"  AutoGenerateWhereClause ="false"
        Select="it.[PeopleID],(it.[FirstName]+' '+it.[LastName]) as FullName" OrderBy="it.PeopleID" 
         EnableFlattening="False">
    </asp:EntityDataSource>

Answer 2

asp:TemplateField   => DataTextField="FullName"  
EntityDatasource    =>  Select="it.[PeopleID],(it.[FirstName]+' '+it.[LastName]) as FullName"