private void dynamicFunctionsButton_Click(object sender, EventArgs e) { #region Dynamic Function Usage Query query = new Query(); Expression<object> functionBody = new Expression<object>(); functionBody.Parameters.Add("firstName", typeof (string)); functionBody.Parameters.Add("lastName", typeof(string)); functionBody.Text = "lastName + ', ' + firstName"; MyFunctionBinding myFunctionBinding = new MyFunctionBinding("CreateFullname", functionBody); // This adds the dynamic function to the data context query.DataContext.Functions.Add(myFunctionBinding); query.Text = "SELECT CreateFullname('Abraham', 'Lincoln') AS Result"; dataGridView1.DataSource = query.ExecuteDataTable(); #endregion }
private void dynamicFunctionsButton_Click(object sender, EventArgs e) { #region Dynamic Function Usage Query query = new Query(); Expression <object> functionBody = new Expression <object>(); functionBody.Parameters.Add("firstName", typeof(string)); functionBody.Parameters.Add("lastName", typeof(string)); functionBody.Text = "lastName + ', ' + firstName"; MyFunctionBinding myFunctionBinding = new MyFunctionBinding("CreateFullname", functionBody); // This adds the dynamic function to the data context query.DataContext.Functions.Add(myFunctionBinding); query.Text = "SELECT CreateFullname('Abraham', 'Lincoln') AS Result"; dataGridView1.DataSource = query.ExecuteDataTable(); #endregion }