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