Having a problem with inserting data into database

Qasim Hafeez

HI there, i tried a lot but i think im missing something here and i really could not find out, for me it seems to be right.

when i run the program and fill the forms the i get an error on savechanges() method ...

using (var db = new StudentEntities())

{

var add = new Book_Record

{

Book_Id = Int32.Parse(txtID.Text),

Book_Title = txtTitle.Text,

Book_Type = txtType.Text,

Book_Author = txtAuthor.Text,

Book_Edition = txtEdition.Text,

Book_IssuedBy = txtIssuedBy.Text,

Book_IssuedTo = txtIssuedTo.Text

};

db.Book_Record.Add(add);

db.SaveChanges();

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan9y ago
Accepted answer
Add a primary key to the table. Make the book_id primary key
+1
Qasim Hafeez9y ago
Problem Solved! i think there was a problem with entity framework 6x version ...
I tried with 5.0 and it worked out ...
Thank u guys for the assistance
+1
Bikesh Srivastava9y ago
Hi,
I think you are doing good ,but you need to change some little bit of code,use break point and post error so that we can help you.
0
Qasim Hafeez9y ago
This is the error message, and bookID is not a PK ...
Thanks in Advanced
0
Bryian Tan9y ago
Yeah. What the error message? I'm guessing it could be the Book_Id which was setup as auto increment in the entity/table or one of the input value string length was too long. :)
+2
Catcher Wong9y ago
Hi Qasim

You need to tell us what errors you meet.
0