Creating Business Data Connectivity Service using Visual Studio 2010

public static void Delete(int empId) { SqlConnection SqlConnection = GetSqlConnection(); SqlConnection.Open(); SqlCommand SqlCommand = new SqlCommand(); SqlCommand.Connection = SqlConnection; SqlCommand.CommandText = "delete from EmployeeTab WHERE EmpId =" empId.ToString(); SqlCommand.ExecuteNonQuery(); SqlConnection.Dispose(); }

public static IEnumerable<Employee> ReadList() { //TODO: This is just a sample. Replace this simple sample with valid code. SqlConnection SqlConnection = GetSqlConnection(); try { List<Employee> allCustomers = new List<Employee>(); SqlConnection.Open(); SqlCommand SqlCommand = new SqlCommand(); SqlCommand.Connection = SqlConnection; SqlCommand.CommandText = "select EmpId, FirstName, LastName from EmployeeTab"; SqlDataReader SqlDataReader = SqlCommand.ExecuteReader(CommandBehavior.CloseConnection); while (SqlDataReader.Read()) { Employee customer = new Employee(); customer.EmpId = int.Parse(SqlDataReader[0].ToString()); customer.FirstName = SqlDataReader[1].ToString(); customer.LastName = SqlDataReader[2].ToString(); allCustomers.Add(customer); } Employee[] customerList1 = new Employee[allCustomers.Count]; for (int customerCounter = 0; customerCounter <= allCustomers.Count - 1; customerCounter ) { customerList1[customerCounter] = allCustomers[customerCounter]; } return (customerList1); } catch (Exception ex) { //throw ex; Employee[] customerlist = new Employee[0]; Employee customer = new Employee(); customer.EmpId = -1; customer.FirstName = "Unable to retrieve data"; customer.LastName = ""; customerlist[0] = customer; return (customerlist); } finally { SqlConnection.Dispose(); } }

public static Employee ReadItem(int id) { //TODO: This is just a sample. Replace this simple sample with valid code. Employee customer = new Employee(); SqlConnection sqlConn = GetSqlConnection(); sqlConn.Open(); SqlCommand SqlCommand = new SqlCommand(); SqlCommand.CommandText = "select EmpId, FirstName, LastName From EmployeeTab WHERE EmpId =" id.ToString(); SqlCommand.Connection = sqlConn; SqlDataReader SqlDataReader = SqlCommand.ExecuteReader(CommandBehavior.CloseConnection); if (SqlDataReader.Read()) { customer.EmpId = int.Parse(SqlDataReader[0].ToString()); customer.FirstName = SqlDataReader[1].ToString(); customer.LastName = SqlDataReader[2].ToString(); } else { customer.EmpId = -1; customer.FirstName = "Customer Not Found"; customer.LastName = ""; } sqlConn.Dispose(); return customer; }

static SqlConnection GetSqlConnection() { string ConnectionString = @"Data Source=chandan-ltp\Sqlexpress;Initial Catalog=ABC;Integrated Security=True"; SqlConnection SqlConn = new SqlConnection(ConnectionString); return SqlConn; }

Correct code of class EmployeeEntityService is...

lot of error in this article..you guys can only follow..for basic creation of BCS using VS 2010

Also can you please post some article related to creating associations in bcs

nice article ,but getting error MethodInstance with Name 'ReadList' on Entity (External Content Type) with Name 'CustomerEntity' in Namespace 'BCS_Customer.BdcModel1' failed unexpectedly. The failure occurred in method 'ReadList' defined in class 'BCS_Customer.BdcModel1.CustomerEntityService' with the message 'Index was outside the bounds of the array

Very good article, very nice

Nice Article, it Really covers all parts of the topic Thanks

Hello Hung, thank you very much for this article. Its very much detailed and has proved useful. When you created the data configurations for sql server, it was quite a drag and drop experience which was nice. Do you have a similar path or article / idea in creating the connectivity for MySql databases?

Thanks. Ok, you can connect to oracle. but i am not expert about it. i am sorry but i can share to link for you: http://msdn.microsoft.com/en-us/library/ff464424(office.14).aspx Regard.

Very Good Article, thanks, can i follow same steps for oracle instead of sql? Thanks Scot