/// <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();
}
