Accessing SQL Server Tables

Ken Wickham 1 Reputation point
2021-09-19T21:10:18.96+00:00

I can only access a subset of my tables. Structure as follows via Access serve explorer:

Data Connections
desktop-1d218ks.MemberEntriesDataSet
Tables
table1
table2
table3
table5
table6
Views
.
My code snip it

using (MemberEntriesDataSetEntities context = new MemberEntriesDataSetEntities())
{
Table1 table = new Table1 Visual Studio identifies the Table1 for me to use.
{};

However if I try table2 (for example) visual studio does not recognize that table and I get an error
'Table2' could not be found (are you missing a directive or an assembly reference?)

Even with Microsoft SQL Server Management Studio, all seems to be just fine.

However when I query using using the Management Studio select * from Table2, the table has a red underling but the query result displays the table2 column names, no error and table is empty.

I hop that I gave you enough to chew on.

Thank you
Ken

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
485 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,307 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2021-09-20T07:57:33.507+00:00

    new MemberEntriesDataSetEntities()

    So you work with EF = Entity Framework? Have you refreshed the model from database to get the latest release version of the DB?

    1 person found this answer helpful.