Sequence not working with LINQ

Asked Apr 13 '17 at 18:58

Active Apr 13 '17 at 18:58

Viewed 53 times

I'm trying to insert data to a table with a sequence to generate an ID automatically. Table and Sequence

CREATE TABLE [dbo].[Hotel] (
[HotelId]          VARCHAR (50)    NOT NULL,
[HotalName]         VARCHAR (50)   NULL,
PRIMARY KEY CLUSTERED ([HotelId] ASC)
);

GO
CREATE SEQUENCE dbo.IDSeq AS
INT START WITH 1
INCREMENT BY 1 ;
GO
ALTER TABLE dbo.Hotel
ADD CONSTRAINT Const_HotelId_Seq
DEFAULT FORMAT((NEXT VALUE FOR dbo.IDSeq),'HO-0000#') FOR HotelId;
GO

I tried to insert data in 2 different ways,

Method 1 (Working method)

INSERT INTO Hotel([HotelName]) VALUES ('Shangrilla')

Method 2(Not working)

DataClassesDataContext dc = new DataClassesDataContext ();
dc.Hotels.InsertOnSubmit(hotel);
dc.SubmitChanges();
dc.Dispose();

Data insertion is not working on code. How may I fix this?

asked Apr 13 '17 at 18:58

codebot

2,540
3
38
89

what version of entity framework? – Daniel A. White Apr 13 '17 at 19:00
Do you get any error? – AnjuRaj Apr 13 '17 at 19:02
SqlException. Not allowed null values on HotelId Column – codebot Apr 13 '17 at 19:02
How may I check the EF version? – codebot Apr 13 '17 at 19:04
1

Your `HotelId` needs the `[DatabaseGenerated(DatabaseGeneratedOption.Identity)]` attribute or something similar let it know not to include it in inserts. – juharr Apr 13 '17 at 19:07
But it's varchar. Not possible to set DbGenerated. It gives an error – codebot Apr 13 '17 at 19:09
Can you please post your model and the 'hotel' object code? – AnjuRaj Apr 13 '17 at 19:09
I'm using LINQ. I didn't create an object for it – codebot Apr 13 '17 at 19:10
1

@codebot Really, what about using `DatabaseGeneratedOption.Computed`? – juharr Apr 13 '17 at 19:10
@codebot Your Linq has to use entities that either you wrote your you had VS create for you. – juharr Apr 13 '17 at 19:11

Sequence not working with LINQ

0 Answers0