public bool Insert(ControleTemperatura control) { try { using (IDbConnection db = new SqlConnection(stringConnection)) { string sqlQuery = "INSERT INTO ControleTemperatura values (@IdSensor, @Data, @Temperatura, @Tensao, @Dados)"; int rowsAffected = db.Execute(sqlQuery, control); return(rowsAffected > 0); } } catch (System.Exception) { Console.WriteLine("Erro ao conectar Banco."); // throw; } return(false); }
public bool InsertMysql(ControleTemperatura control) { string stringConnectionMysql = @"Server=192.168.137.131;Database=test;Uid=root;Pwd=Password1;"; try { using (IDbConnection db = new MySqlConnection(stringConnectionMysql)) { string sqlQuery = "INSERT INTO ControleTemperatura (idsensor,data,temperatura,tensao,dados) values (@IdSensor, @Data, @Temperatura, @Tensao, @Dados)"; int rowsAffected = db.Execute(sqlQuery, control); return(rowsAffected > 0); } } catch (System.Exception ex) { Console.WriteLine("Erro ao conectar Banco." + ex.Message); // throw; } return(false); }