LinqPad now showing table if a SP has same name
There seems to be some problems with LINQPAD when an SP and Table has the same Name, but written differently (Capital letters)
If you run these 2 SQL scripts, you will only see the SP as an option in linqpad:
CREATE TABLE [dbo].[VIPs](
[ID] [int] IDENTITY(1,1) NOT NULL,
[MobileNumber] varchar NULL
CREATE PROCEDURE [search].[Vips]
,@index INT = 0
,@count INT = 10
,@JSONDATA NVARCHAR(MAX) OUTPUT
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
SET @JSONDATA = 'Test'
If you change the Procedure to have exact name as the table written like "VIPs" both are shown.
How come? This seems to be a bug?
Are there any ways to force LINQPAD to always set "Scheme" in front of a method?