clr stored procedure object type input parameters ?

Question

Please give me example for clr stored procedure object type input parameters ?

Arjun V · Answer

Thank Promod but I want total store procedure my input parameter object like json object like below so how to handle it { "name":"arjun", "age":30, "cars": { "car1":"Ford", "car2":"BMW", "car3":"Fiat" } }

Pramod Thakur · Answer

You can try this.. public void InsertRecord(Employee objEmployee) { try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ "mycon" ].ToString()); string query = "INSERT INTO tblEmployees VALUES(@Name, @Gender, @City, @Salary) " ; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue( "@Name" , objEmployee.Name); cmd.Parameters.AddWithValue( "@Gender" , objEmployee.Gender); cmd.Parameters.AddWithValue( "@City" , objEmployee.City); cmd.Parameters.AddWithValue( "@Salary" , objEmployee.Salary); con.Open(); cmd.ExecuteScalar(); con.Close(); } catch { throw ; } }

Pramod Thakur · Answer

Can you share your problem..

clr stored procedure object type input parameters ?

Answers (3)