SharePoint Study Notes-splist-indirect query of the external list using LINQ to SharePoint (1. Create an external list using BCS)

Source: Internet
Author: User

LINQ to SharePoint does bring us a lot of convenience, saving us from the hassle of using calm, but when we use the spmetal tool (spmetal details) this tool does not work on the external list. For other restrictions on the external list, see (restrictions on SharePoint Study Notes --- splist -- external list ),
In some special cases, we need to use LINQ to Sharepoint to query the data in the external list. To solve this problem, we only need to use an alternative method, the method here is limited to the query function. The idea is to create a customer list and create a lookup field on this list to quickly reference the field on the external list (avoiding manual orCodeThe trouble of creating the required fields), and then use LINQ to SharePoint on this customer list. Therefore, the implementation is roughly divided into three parts (each part can also be used separately ).
1. Create an external list through BCS.
2. Create a customer list and quickly copy the items of the external list to the lookup field group of the customer list through code.


{SharePoint Study Notes --- splist -- indirect query of external list using LINQ to SharePoint (2. Copy external list content)
}

3. Use LINQ to SharePoint on the customer list to indirectly query the external list data through such a replacement.

{SharePoint Study Notes --- splist -- indirect query of external list by using LINQ to SharePoint (3. query list content by using LINQ to SharePoint )}

This article describes the first step: Create an external list by using BCS. The data source we use is the SQL Server database northwind.

 


We will create an external list (named nwcustomer) on our test website ). The procedure is as follows.

1. Open our website in SharePoint designer and go to the external content type Creation Interface

 

2. on the external content type creation page, click external content type (new) to create a new external content type.

 

 

3. Search for external data sources and define related operations

 

Add new external data source connection

Define external data source types


Define External SQL server data source connection Parameters

 

Define operations for external data sources


All the way to next

 

 

4. Use the BCS connection just created on the test website

 


On the more options page, select the create external list option.

Set related parameters (LIST Parameters and BCS connection parameters)

The following are the nwcustomer display results after creation:

 

 

Next article:SharePoint Study Notes --- splist -- indirect query of the external list using LINQ to SharePoint (2. Copy the external list content)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.