Participant
1550 Points
1125 Posts
Dec 08, 2012 11:19 AM|eric2820|LINK
I have a test project up running and published, now all I need is a way to get it to you. The zip file is 834 KB in size.
You can reach me at EircDill@outlook.com
And here is the create script for the Music table.
USE [My-MSI.Net]
GO
/****** Object: Table [dbo].[Music] Script Date: 12/08/2012 12:05:38 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[Music](
[id] [decimal]
(18, 0) NOT NULL,
[songName] [nvarchar]
(50) NOT NULL,
[artist] [nvarchar]
[album] [nvarchar]
[time] [datetime2]
(7) NOT NULL,
[music] [varbinary]
(max) NOT NULL,
CONSTRAINT [PK_Music] PRIMARY KEY CLUSTERED ( [songName] ASC, [artist] ASC, [album] ASC, [time] ASC )
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
SET ANSI_PADDING OFF
Participant
1550 Points
1125 Posts
Re: EF returning two identical records when 2 different records are in the table.
Dec 08, 2012 11:19 AM|eric2820|LINK
I have a test project up running and published, now all I need is a way to get it to you. The zip file is 834 KB in size.
You can reach me at EircDill@outlook.com
And here is the create script for the Music table.
USE [My-MSI.Net]
GO
/****** Object: Table [dbo].[Music] Script Date: 12/08/2012 12:05:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Music](
[id] [decimal]
(18, 0) NOT NULL,
[songName] [nvarchar]
(50) NOT NULL,
[artist] [nvarchar]
(50) NOT NULL,
[album] [nvarchar]
(50) NOT NULL,
[time] [datetime2]
(7) NOT NULL,
[music] [varbinary]
(max) NOT NULL,
CONSTRAINT [PK_Music] PRIMARY KEY CLUSTERED
(
[songName] ASC,
[artist] ASC,
[album] ASC,
[time] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
)
ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
http://www.my-msi.net/Admin
blog
If a post helps you, please mark it as Ansered, thank-you.