public void DSDBWrapperTransSqlNoCommitTestBug1857() { Database db = new GenericDatabase(@"server=(local)\SQLEXPRESS;database=Northwind;Integrated Security=true", SqlClientFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { string sqlCommand = "select * from [Order Details]"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction); } } }
public void DSDBWrapperTransSqlNoCommitTestBug1857() { Database db = new GenericDatabase(@"server=(localdb)\v11.0;database=Northwind;Integrated Security=true", SqlClientFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { string sqlCommand = "select * from [Order Details]"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction); } } }
public void DSDBWrapperTransSqlNoCommitTestBug1857() { Database db = new GenericDatabase(String.Format(@"server={0};database=Northwind;Integrated Security=true", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), SqlClientFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { string sqlCommand = "select * from [Order Details]"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction); } } }
/// <summary> /// Retorna a versão do servidor de Banco de dados. /// </summary> public string GetVersion() { try { dbCommand = db.GetSqlStringCommand("SELECT version();"); return(db.ExecuteScalar(dbCommand).ToString()); } catch { throw; } }
/// <summary> /// Verifica a existência de um Banco de dados específico no servidor. /// </summary> /// <param name="databasename">Nome do Banco de dados</param> /// <returns>VERDADEIRO caso já exista o Banco de dados</returns> public bool ExistsDatabase(string databasename) { try { dbCommand = db.GetSqlStringCommand("SELECT datname FROM pg_database" + " WHERE datname = @databasename;"); db.AddInParameter(dbCommand, "@databasename", DbType.String, databasename); using (IDataReader DR = db.ExecuteReader(dbCommand)) { DR.Read(); DR["datname"].ToString(); return(true); } } catch { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!String.IsNullOrEmpty(Request.QueryString["id"])) { newsid.Attributes["ref"] = Request.QueryString["id"]; string newsitem = "<div class='subitem top10 newsitem'><div class='delete-item'>DELETE</div><div class='top10 itemtitle'>~name~</div><div class='formitem top10'><label for='newstitle'>News Title</label><input name='' class='newstitle' value='~title~' /></div><div class='formitem top10'><label for='newstitle'>News Source</label><input name='' class='newssource' value='~source~' /></div><div class='formitem top10'><label for='newstitle'>News Date</label><input name='' class='newsdate' value='~date~' /></div><div class='top10'>Story Content</div><textarea class='leadin rtf top10' id='~newsid~'>~content~</textarea></div>"; string highlightitem = "<div class='subitem top10 highlightitem'><div class='delete-item'>DELETE</div><div class='top10 itemtitle'>~name~</div><div class='formitem top10'><label for='highlighttitle'>Highlight Title</label><input name='' class='highlighttitle' value='~title~' /></div><div class='formitem top10'><label for='highlightlink'>Highlight Link: Please put the full URL in this field including the 'http://'</label><input name='' class='highlightlink' value='~source~' /></div></div>"; Entry item = new Entry(); DataTable dtFB = null; GenericDatabase db = new GenericDatabase(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, DbProviderFactories.GetFactory("MySql.Data.MySqlClient")); DbCommand cmd = db.GetSqlStringCommand("Select * from media where id ='" + Request.QueryString["id"] + "'"); dtFB = db.ExecuteDataSet(cmd).Tables[0]; cmd.Dispose(); foreach (DataRow row in dtFB.Rows) { item.LeadIn = row["leadin"].ToString(); item.Count = row["newscount"].ToString(); item.NewItems = row["newsitem"].ToString(); item.HighlightItems = row["highlightitem"].ToString(); newsid.InnerText = row["name"].ToString(); } leadin.Value = item.LeadIn; List <News> newitems = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize <List <News> >(item.NewItems); string tmp = ""; Int32 ctr = 1; foreach (News x in newitems) { tmp += newsitem.Replace("~name~", "News " + ctr.ToString()).Replace("~title~", x.Title).Replace("~source~", x.Source).Replace("~date~", x.Date).Replace("~newsid~", "news" + ctr.ToString()).Replace("~content~", x.Content); ctr++; } news.InnerHtml = tmp; tmp = ""; List <Highlight> highitems = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize <List <Highlight> >(item.HighlightItems); ctr = 1; foreach (Highlight x in highitems) { tmp += highlightitem.Replace("~name~", "Highlight " + ctr.ToString()).Replace("~title~", x.Title).Replace("~source~", x.Source); ctr++; } highlights.InnerHtml = tmp; //leadin.Value = item.LeadIn; storycount.Value = item.Count; } DataTable dtFBa = null; GenericDatabase dba = new GenericDatabase(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, DbProviderFactories.GetFactory("MySql.Data.MySqlClient")); DbCommand cmda = dba.GetSqlStringCommand("Select id, name from media order by id desc"); dtFBa = dba.ExecuteDataSet(cmda).Tables[0]; cmda.Dispose(); ListItem mn = new ListItem(); mn.Text = "Select Saved Email Template"; mn.Value = "0"; ddmenu.Items.Add(mn); foreach (DataRow row in dtFBa.Rows) { mn = new ListItem(); mn.Text = row["name"].ToString(); mn.Value = row["id"].ToString(); ddmenu.Items.Add(mn); } }