public int AddRecipeToDatabase(Recipe recipe) { var conn = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString); StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO recipe_schema.recipe" + "({0},{1},{2}) VALUES ('{3}', '{4}', '{5}')", "Name", "Contributor", "Description", recipe.Name, recipe.Contributor, recipe.Description); conn.Query(sb.ToString()); return((int)(UInt64)conn.ExecuteScalar("SELECT LAST_INSERT_ID()")); }
public T ExecuteScalar <T>(string connection, string sql, object parameters) { T result = default; using (var c = new MySqlData.MySqlClient.MySqlConnection(connection)) { _log.LogTrace <MySqlQuery>($"EXECUTE: {sql}. Parameters: {JsonConvert.SerializeObject(parameters)}"); c.Open(); result = c.ExecuteScalar <T>(sql, parameters); c.Close(); } return(result); }
/// <summary> /// ExecuteScalar 執行一個SQL命令返回結果集的第一列的第一行。 /// </summary> /// <param name="sql"></param> /// <returns></returns> public object ExecuteScale(string sql) { object oo = null; try { //using (var cn = new System.Data.SqlClient.SqlConnection(ConnStr)) //{ // oo = cn.ExecuteScalar(sql); //} if (_ProviderName == "System.Data.SqlClient") { using (System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConnStr)) { oo = cn.ExecuteScalar(sql); } } else if (_ProviderName == "MySql.Data.MySqlClient") { using (MySql.Data.MySqlClient.MySqlConnection cn = new MySql.Data.MySqlClient.MySqlConnection(ConnStr)) { oo = cn.ExecuteScalar(sql); } } else { using (System.Data.SqlClient.SqlConnection cn = SqlClient) { oo = cn.ExecuteScalar(sql); } } } catch (Exception ex) { throw ex; } return(oo); }