Business Data Catalog Sample File

<LobSystem
   Type="Database"
   Version="1.0.0.01"
   Name="AdventureWorks"
   xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">


<AccessControlList>
   <AccessControlEntry Principal="domain\you">
      <Right BdcRight="Execute"/>
      <Right BdcRight="Edit"/>
      <Right BdcRight="SetPermissions"/>
      <Right BdcRight="SelectableInClients"/>
   </AccessControlEntry>
   <AccessControlEntry Principal="domain\BDCUsers">
      <Right BdcRight="Execute"/>
      <Right BdcRight="SelectableInClients"/>
   </AccessControlEntry>
</AccessControlList>


<LobSystemInstances>
   <LobSystemInstance Name="AdventureWorksDB">
      <Properties>
         <Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
         <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
         <Property Name="RdbConnection Data Source" Type="System.String">SQLServerMachineName</Property>
         <Property Name="RdbConnection Initial Catalog" Type="System.String">AdventureWorks</Property>
         <Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>
      </Properties>
   </LobSystemInstance>
</LobSystemInstances>

<Entities>
 <Entity Name="Customer">

  <Properties>
   <Property Name="Title" Type="System.String">Name</Property>
  </Properties>
 
  <Identifiers>
   <Identifier Name="CustomerID" TypeName="System.Int32"/>
  </Identifiers>
     

  <Methods>
   <Method Name ="GetCustomers">
              <Properties>
           <Property Name="RdbCommandText" Type="System.String">
             SELECT CustomerID,LastName + ', ' + FirstName as Name,Phone, EmailAddress
             FROM Sales
           </Property>

    <Property Name="RdbCommandType" Type="System.String">Text</Property>
            </Properties>

              <Parameters>
     <Parameter Direction="Return" Name="Customers">
         <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="CustomerDataReader">
            <TypeDescriptors>
       <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data,Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="CustomerDataRecord">
       <TypeDescriptors>
                     <TypeDescriptor TypeName="System.Int32" IdentifierName="CustomerID" Name="customerID" />
                     <TypeDescriptor TypeName="System.String" Name="Name" />
                     <TypeDescriptor TypeName="System.String" Name="Phone" />
                     <TypeDescriptor TypeName="System.String" Name="EmailAddress" />
       </TypeDescriptors>
       </TypeDescriptor>
            </TypeDescriptors>
      </TypeDescriptor>
     </Parameter>
    </Parameters>

    <MethodInstances>
                   <MethodInstance
           Name="CustomerFinderInstance" Type="Finder"                         ReturnParameterName="Customers"      ReturnTypeDescriptorName="CustomerDataReader" />
 
    </MethodInstances>

   </Method>
  </Methods>
 </Entity>
</Entities>

</LobSystem>

Articles:
http://msdn.microsoft.com/en-us/office/bb251754.aspx