Elastic Search using asp.net, c# and SqlServer

create table TempDST
(
Cutomerid int primary key identity(1,1),
CustomerName varchar(50),
Location varchar(50)
)

--Insert into TempDST values ('Abc','Mumbai')
--Insert into TempDST values ('Xyz','Delhi')
--Insert into TempDST values ('Pqr','Bangalore')

Cutomer id ----	Customer Name ---	Location
---------------------------------------------------
1---	Abc	--- Mumbai
2---	Xyz	--- Delhi
3---	Pqr	--- Bangalore.

create proc sp_GetCustomer(@CustId int)
as
begin
	Select Cutomerid,CustomerName,Location from TempDST	 where Cutomerid=@CustId
END

exec sp_GetCustomer 1

1	Abc	Mumbai

SqlConnection myConnection = new SqlConnection(dsn);
            SqlCommand myCommand = new SqlCommand("exec sp_GetCustomer  @CustId ", myConnection);
            myCommand.Parameters.Add(new SqlParameter("@CustId", SqlDbType.Int));
           myCommand.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter sqlAdapter = new SqlDataAdapter(myCommand);
            //create a new dataset to hold our data
            DataSet ds = new DataSet();
            //fill the dataset with the result of our query from the specified command
            sqlAdapter.Fill(ds);

{
    "sql":"select Cutomer_id, Customer_Name, Location from orders",
    "index":"orders",
    "filter" : {
        "term" : { 
            "id" : "1" 
        }
    },
}