Step by step working with SharePoint BCS

To do.
1) Create a table in your SQL server database. Script is below.

CREATE TABLE [dbo].[TblBCS](

[ID] [nchar](10) NULL,[Name] [varchar](50) NULL,[LastName] [varchar](50) NULL)
ON [PRIMARY])

2) Go to CA -> System settings -->Manage services on server 

   Check the "Secure Store Service" is working fine.

3) Create a user account at domain leve, I have created "kumarsji"
4) Go to CA > Application management   >  Manage service applications
5) Go to "secure store service"
6) click on the new button on the ribbon menu.

 
7) Enter the details as below, Check also Contact E-mail .

8) Click on next.

9) Do not change anything click on next.

10) Select Site collection Admin in the first box and put users to other box as below.

11) After clicking on ok button , We have to set credential as below.

12) Will set the credential as below.

13) Go to sharepoint designer open site go to external content type.As below.