Basic CRUD operations on Azure DB from MVC 5 application

I have built a very basic mvc application. I need it to have basic CRUD functionality. My database is located on Azure. When I try to create a new record in my mvc application it does not load into my Azure database. I followed the tutorial on the Microsoft website for using EF6. I used scaffolding to create the new view and controller once I connected the Azure database and none of the crud functionality works. This is the code for the "create" portion

        // POST: Venues/Create
    // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
    // more details see https://go.microsoft.com/fwlink/?LinkId=317598.
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult Create([Bind(Include = "VenueID,VenueName,VenueAdd,VenueCity,VenueState,VenueCountry,VenueCounty,VenueZip,VenuePhone,VenueFax,VenueContactName,VenueContactEmail,VenueContactPhone,VenueWebsite,VenueLat,VenueLong,VenueRating")] Venue venue)
    {

            if (ModelState.IsValid)
            {
                db.Venues.Add(venue);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
        }

        return View(venue);
    }

It is very basic that is why I am not sure why it isn't working This is the link I want to function

The Azure database is empty. I have used the ado entity model in visual studio to connect to the database. It is an .edmx file

ok this may help a lot - I was able to step through the code and I received this exception

Message = "Unable to update the EntitySet 'Venue' because it has a DefiningQuery and no element exists in the element to support the current operation."

So it looks as if there is no insert function - at least that is what I am thinking but wasn't that created when I did the scaffolding?