Same Table name but different Schema : - LinqPad not showing the 2nd Table

jayonsoftware

Got some thing like this

dbo.Sales
crm.Sales

Both are on the same DB.

When LinqPad populates its left side pane with table names, the 2nd table name is missing.

Jay

JoeAlbahari

Are you sure it's not there with a different name, like crm_sales?

jayonsoftware

Nope not showing. I can send a screen shot. Let me know which email ID

JoeAlbahari

Can you instead please post the schema, preferably the simplest schema that will reproduce the problem?

The following works correctly for me:

create table dbo.Sales (ID int primary key)
go
create schema crm
go
create table crm.Sales (ID int primary key)

I can then go:

Sales.Dump();
Crm_Sales.Dump();

denwiz

You may need to refresh the database in the left side panel (see Linq Multi Schema Select)

jt6414

This is still an issue when you happen to have the same table names but with different casing. For example:

create table dbo.sales (ID int primary key)
go
create schema crm
go
create table crm.Sales (ID int primary key)

denwiz

jt6414 - You're right. When I tried to create a table with the same name (but different case) on a different schema, the schema node goes missing (see Missing Schema Node) in LINQPad (v 4.51.03).

Probably something for Joe to look into for the next version.

jayonsoftware

I got the latest beta and I still see the issue. We got 2 Tables

CREATE TABLE [CRM].[Transactions]
CREATE TABLE [Sales].[transactions]

The 2nd one shows on the left pane, not the first one.

Thanks

Jay