View - Update From Source

I'm having an issue where I've created a view and used the model designer to drag my view over into my visual studio project. When I go to use Update From Source... Lightspeed wants to remove the entity.. I'm really confused by this.

Because this is an entity created to support the view its not backed by a table which is why it thinks all the properties should be removed. You will need to ignore this entity on database updates as we are expecting a table to be present to derive the information from for the two way sync.

Jeremy

Okay, then I should be able to use the Entity without issues?

I'm getting an ASP error: Invalid object name 'Staffmember'. Please see attached photos.

You are not specifying a view name in your query - currently your query against the entity is expecting to use a backing table as thats the default approach which is why you are seeing an error (there is no backing table!). You need to use the .ViewName() extension method with your LINQ query when working with that entity to indicate to LightSpeed that you want to query using the view rather than a backing table.

e.g. as per http://www.mindscapehq.com/documentation/lightspeed/Advanced-Querying-Techniques/Exploring-the-Query-Object

Specify the ViewName property to run the query against a view instead of against the entity’s normal backing table. See Working with Database Views in the chapter Controlling the Database Mapping for details.

If you are using LINQ you can use the .WithViewName extension method

Jeremy

Jeremy, I revised my ActionResult method to the following:

    public ActionResult Index(string position)
    {
        var churchstaff = UnitOfWork.Staffmembers.WithViewName("staffmembers").Where(staffmember => staffmember.Active && staffmember.Showasstaff)
            .OrderBy(staffmember => staffmember.Positionid)
            .ThenBy(staffmember => staffmember.Displayorder);

        if (!String.IsNullOrEmpty(position))
        {
            if (churchstaff.Any(staffmember => staffmember.Position == position))
            {
                churchstaff = (IOrderedQueryable<Staffmember>) churchstaff.Where(staffmember => staffmember.Position == position);
            }
        }
        return View("Index", new StaffViewModel { Staff = churchstaff });
    }

It appears I'm getting entries, however all the data in the entries are null. Any advice?

[Update] I was able to resolve this.