public void DeleteSQL(Generic entity)
        {
            db = new MydbContex();
            var returnObject = entity.Obj;
            var type         = returnObject.GetType();
            var dbcontext    = db.Set(type);

            dbcontext.Remove(returnObject);
        }
        public Generic GetSQL(Guid Id, Type type)
        {
            db = new MydbContex();
            var dbcontext      = db.Set(type);
            var returnedObject = dbcontext.Find(Id);

            db.SaveChanges();
            return(Generic.ToGeneric(returnedObject));
        }
        public void InsertSQL(Generic entity)
        {
            db = new MydbContex();
            var returnObject = entity.Obj;
            var type         = returnObject.GetType();
            var dbcontext    = db.Set(type);

            dbcontext.Add(returnObject);
            db.SaveChanges();
        }
        public DbSqlQuery GetAllSQL(Generic entity)
        {
            db = new MydbContex();
            Type type         = entity.Obj.GetType();
            var  returnObject = entity.Obj;
            var  dbcontext    = db.Set(type);
            var  consulta     = dbcontext.SqlQuery("Select * From " + type);

            db.SaveChanges();
            return(consulta);
        }
        public void UpdateSQL(Generic entity)
        {
            db = new MydbContex();
            Type type         = entity.Obj.GetType();
            var  returnObject = entity.Obj;
            var  dbcontext    = db.Set(type);

            dbcontext.Remove(entity);
            dbcontext.Add(returnObject);
            db.SaveChanges();
        }