protected WEDEPXEntities GetConnection() { if (db == null) { db = new WEDEPXEntities(); } return(db); }
public DataTable ExecuteQuery(string sqlQuery) { WEDEPXEntities db = GetConnection(); DbProviderFactory dbFactory = DbProviderFactories.GetFactory(db.Database.Connection); using (var cmd = dbFactory.CreateCommand()) { cmd.Connection = db.Database.Connection; cmd.CommandType = CommandType.Text; cmd.CommandText = sqlQuery; using (DbDataAdapter adapter = dbFactory.CreateDataAdapter()) { adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); return(dt); } } }
public WedepxDbHelper() { _db = GetConnection(); }
private string Image = System.Configuration.ConfigurationManager.AppSettings["PathImage"]; //"C://WEDEPX//GenImage"; public WedepxService() { _db = GetConnection(); }