/// <summary> /// Ejecuta ina sql Scalar. /// </summary> /// <param name="sql">Query a ejecutar.</param> /// <returns>Valor entero devuelto por el Scalar.</returns> protected int ExecuteScalar(string query) { if (uniqueconn == null) { connect(); } DbCommand command = sql.Command(query, conn); int ret = Convert.ToInt32(command.ExecuteScalar()); if (uniqueconn == null) { disconnect(); } return(ret); }
private void InitBD() { string connString = ConfigurationManager.ConnectionStrings["GebatDataConnectionString"].ConnectionString; connString += "Password=root"; string provider = ConfigurationManager.ConnectionStrings ["GebatDataConnectionString"].ProviderName; ISql manager = FactorySql.Create(provider); FileInfo file = new FileInfo(scriptfilename); StreamReader lector = file.OpenText(); string script = lector.ReadToEnd(); lector.Close(); DbConnection conn = manager.Connection(connString); conn.Open(); DbCommand comando = manager.Command(script, conn); comando.ExecuteNonQuery(); conn.Close(); }