Post by vode on Feb 12, 2010 5:12:02 GMT -5
I have found a ISNULL() conversion issue
The next query is successfully converted:
But if I want to change the default value to float which contains point I got an error:
SQL cannot be converted to LINQ: Field [1].[5] not found in the current Data Context.
Database script:
Good luck!
The next query is successfully converted:
SELECT [AID]
,[Name]
,ISNULL([Value], 1)
FROM [A]
But if I want to change the default value to float which contains point I got an error:
SELECT [AID]
,[Name]
,ISNULL([Value], 1.5)
FROM [A]
SQL cannot be converted to LINQ: Field [1].[5] not found in the current Data Context.
Database script:
CREATE TABLE [A](
[AID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
[Value] [float] NULL,
CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED
(
[AID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [B](
[BID] [int] IDENTITY(1,1) NOT NULL,
[BValue] [float] NULL,
[AID] [int] NULL,
CONSTRAINT [PK_B] PRIMARY KEY CLUSTERED
(
[BID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [B] WITH CHECK ADD CONSTRAINT [FK_B_A] FOREIGN KEY([AID])
REFERENCES [A] ([AID])
GO
ALTER TABLE [B] CHECK CONSTRAINT [FK_B_A]
GO
Good luck!
