Invalid object name 'dbo.vw_Formulieren'. (view error)

Posts   
 
    
Stephan
User
Posts: 63
Joined: 16-Jan-2007
# Posted on: 15-Jan-2008 10:07:13   

Hi, I have the following exception: Invalid object name 'dbo.vw_Formulieren'. (where the vw_Formulieren is my custom view of course).

I added a view to the dB and generated the DAL. Compiling works fine, In LLBLGen the view is added with the correct name. Application compiles fine. But when I try to get the view I get this error which is returned from TypedListDAO.cs in the DAL

I just this function to get the view:


  public static FormulierenTypedView GetFormulieren(Int32 clientId)
        {
            FormulierenTypedView formulierenView = new FormulierenTypedView();
            IPredicateExpression formulierFilter = new PredicateExpression(FormulierenFields.ClientId == clientId);
            ISortExpression formulierSort = new SortExpression(FormulierenFields.AanmaakDatum | SortOperator.Descending);

            formulierenView.Fill(0, null, false, formulierFilter);

            if (formulierenView.Count.Equals(0))
                return null;
            else return formulierenView;
        }

Now I get the error on line 49 of the TypelistDAO.cs : return base.PerformGetMultiAsDataTableAction(fieldsToReturn, tableToFill, maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, allowDuplicates, groupByClause, transactionToUse, pageNumber, pageSize);

I used this construction before without a problem. Am I missing something here?

I use LLBLGen 2.5 (Selfservicing) on the 2.0 framework with a SQL 2005 DB

Stephan
User
Posts: 63
Joined: 16-Jan-2007
# Posted on: 15-Jan-2008 10:20:14   

Sorry, this is very stupid. I was connection to the wrong DB.