New Create Database name BCSForSharePoint2010
Open Visual Studio 2010 to create a new BCS
Aspired to become a SharePoint? Explore the post to discover the know-how on the "SharePoint Training" course.
The interface creates the following new
Rename the Class Entity1 CustomerEntity
Rename the primary key of CustomerID from Identifier1
In the Properties window of the CustomerID, Name Type: select System.Int32
BDC Explorer window Expand Model | Expand BdcModel1 | Expand CustomerEntity | Expand ReadItem | Expand id and choose Identifier
Rename the primary key of CustomerID from Identifier1
-In the Properties window of the CustomerID, Name Type: select System.Int32
-Selected the following image
Expand Model | Expand BdcModel1 | Expand CustomerEntity | Expand ReadItem | Expand return parameter and select Entity1
-Change from the Customer Entity1
-In the customer select the CustomerID and choose Identifier1 Name Type: select System.Int32
-Renamed CustomerName, Type Name: System. String
-Click to Customer | Add Type Descriptor
-Named the City, the Type Name: System.String
-Expand Model | Expand BdcModel1 | Expand CustomerEntity | Expand ReadList | Expand return parameter and select Entity1List
-
CustomerList changed
-Expand Model | Expand BdcModel1 | Expand CustomerEntity | Expand ReadList | Expand return parameter | Expand CustomerList | Choose Entity1
Customer changed
-Expand Customer | Change Identifier1 the CustomerID
-In the Properties window of the CustomerID, Name Type: select System.Int32
-Select Message and renamed CustomerName, Type Name: System. String
-Click to Customer | Add Type Descriptor
-Named the City, the Type Name: System. String
Solution Explorer window | Select Class Entity1
Method Details window BDC - CustomerEntity | collap ReadItem method, ReadList Click the Add method in the combo box and select the Create Delete Method Member
Interface as follows
• Double click on the file and found ReadItem method appears CustomerEntityService.cs • Using the following declaration code using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; • Declare the SqlConnection method returns the name GetSqlConnection GetSqlConnection static SqlConnection () { string ConnectionString = "server = (local) database = BCSForSharePoint2010; Integrated Security = true"; SqlConn SqlConnection = new SqlConnection (ConnectionString); sqlConn return; } • In the alternative method ReadItem error code with the following code: public static ReadItem Customer (int id) { Customer customer = new Customer (); SqlConn = GetSqlConnection SqlConnection (); sqlConn.Open (); SqlCommand SqlCommand = new SqlCommand (); sqlCommand.CommandText = "select CustomerID, CustomerName, City" + "From Customer" + "WHERE CustomerID =" + id.ToString (); sqlCommand.Connection = sqlConn; SqlDataReader SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior. CloseConnection); if (sqlDataReader.Read ()) { customer.CustomerID = int. Parse (SqlDataReader [0]. ToString ()); customer.CustomerName = SqlDataReader [1]. ToString (); Customer.City = SqlDataReader [2]. ToString (); } else { customer.CustomerID = -1; customer.CustomerName = "Customer Not Found"; Customer.City = ""; } sqlConn.Dispose (); return customer; } • In the method declaration code ReadList / / / <summary> / / / This is a sample method for Entity1 finder. / / / If You Want to delete or rename the method to think about changing the xml file in the BDC model as well. / / / </ Summary> / / / <returns> IEnumerable of Entities </ returns> public static IEnumerable <Customer> ReadList () { SqlConnection SqlConnection = GetSqlConnection (); try { List <Customer> allCustomers = new List <Customer> (); sqlConnection.Open (); SqlCommand SqlCommand = new SqlCommand (); sqlCommand.Connection = SqlConnection; sqlCommand.CommandText = "select CustomerID, CustomerName, City from Customer"; SqlDataReader SqlDataReader = sqlCommand.ExecuteReader (CommandBehavior. CloseConnection); while (sqlDataReader.Read ()) { Customer customer = new Customer (); customer.CustomerID = int. Parse (SqlDataReader [0]. ToString ()); customer.CustomerName = SqlDataReader [1]. ToString (); Customer.City = SqlDataReader [2]. ToString (); allCustomers.Add (customer); } Customer [] = new Customer customerList [allCustomers.Count]; for (int customerCounter = 0; customerCounter <= allCustomers.Count - 1; customerCounter + +) { customerList [customerCounter] = allCustomers [customerCounter]; } return (customerList); } catch (Exception ex) { Tellme String = ex.Message; Customer [] customerlist = new Customer [0]; Customer customer = new Customer (); customer.CustomerID = -1; customer.CustomerName = "Unable to retrieve data"; Customer.City = ""; customerlist [0] = customer; return (customerlist); } finally { sqlConnection.Dispose (); } } • In the Delete method declaration code public static void Delete (int CustomerID) { SqlConnection SqlConnection = GetSqlConnection (); sqlConnection.Open (); SqlCommand SqlCommand = new SqlCommand (); sqlCommand.Connection = SqlConnection; sqlCommand.CommandText = "delete customer WHERE CustomerID =" + customerID.ToString (); sqlCommand.ExecuteNonQuery (); sqlConnection.Dispose (); } After completion code hi build and Deploy project
Open Central Administration | Application Management | Manage service selected applications You choose to Business Data Connectivity Service You check CustomerEntity BCSCustomer.BdcModel1 with namespace and select Icon Set Object Permissions Add your user rights for that user and select
Open the site with the port as was at first Debugging ( http://acer:8888 ) and select All Site Content Choose Create Data at the category | select External List | select Create BCSCustomer named below and select the icon to add External Content Type Choose BdcModel1 with External Content Type and select OK BCSCustomer.BdcModel1.CustomerEntity
For an in-depth understanding of SharePoint click on:
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox