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..