Local database in Visual Studio wpf, data adding doesnt work

Asked Feb 01 '15 at 16:45

Active Feb 01 '15 at 17:22

Viewed 147 times

I am trying to add some data to my empty table OBJEDNAVKY(columns:CisloStolu,Cena,Zaplacena,Nazev) in local database MDF (using Ado.Net Data Entity Model), in Visual Studio 2013. But it doesn't work.

Can you find the problem? Here is the code.

public void VlozObjednavkuDb(int Cena, int CisloStolu, int zaplacena, string nazev)
{
    using (JidelnicekEntities4 databaze = new JidelnicekEntities4())
    {
        try{
            Objednavky objednavka = new Objednavky
                {
                    CisloStolu = CisloStolu,
                    Cena = Cena,
                    Zaplacena = zaplacena,
                    Nazev = nazev
                };
            databaze.Objednavkies.Add(objednavka);
            databaze.SaveChanges();
        }
        catch (Exception) { MessageBox.Show("Ojednavka nebyla provedena"); }
    }
}

I was trying to add some data from listbox first, so I tried to add some basic data, but it doesn't work even with this.

VlozObjednavkuDb(1, 1, 0, "p");

The table stays empty.

Thank you for every advice.

edited Feb 01 '15 at 17:22

Nikolay Kostov

16,433
23
85
123

asked Feb 01 '15 at 16:45

sustekj

Show the connection string – The One Feb 01 '15 at 17:28
SaveChanges returns the number of rows affected in the database do ` x= databaze.SaveChanges();` and check the value of X, if x > 0 then you're updating the wrong file – The One Feb 01 '15 at 17:34
Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\VisualStudio\Restaurace\Restaurace\Jidelnicek.mdf;Integrated Security=True – sustekj Feb 01 '15 at 17:35
JAT , I've tried your suggestion and x = 0 . – sustekj Feb 01 '15 at 17:38
Try databaze.Entry(objednavka).State = EntityState.Added; before calling SaveChanges – The One Feb 01 '15 at 18:26
Thank you , but anyway, im going to work with sdf, I found out its more useful for my small program. – sustekj Feb 01 '15 at 18:32
Still the same problem, its not adding anything to database, but I can read from it. Even with your last help..any other suggestions? – sustekj Feb 04 '15 at 19:50
Is it catching an error? – The One Feb 04 '15 at 20:11
Yes! on databaze.SaveChanges(); – sustekj Feb 06 '15 at 19:04
And what is the error? – The One Feb 07 '15 at 13:19
DbUpdateException ... An error occurred while updating the entries. – sustekj Feb 07 '15 at 17:02
What else? Inner exception? – The One Feb 07 '15 at 17:10
http://s27.postimg.org/5uxxrspmr/inner_Ex.png – sustekj Feb 07 '15 at 17:27
Yeah, read the error, "A duplicate value cannot be inserted into a unique index ... PK_Objednavky" You're trying to insert an Objednavky with a key that already exists. – The One Feb 07 '15 at 17:56
Whats your primary key? Cena? – The One Feb 07 '15 at 17:57
I see, but my primary key is Id – sustekj Feb 07 '15 at 18:54
Can you check if the Id column's identity is set to auto increment? – The One Feb 07 '15 at 19:01
Yes, I already fixed that, it doesnt show any error now, but still not updating the Database. – sustekj Feb 07 '15 at 19:03
Make the x= databaze.SaveChanges() test again, what is x? – The One Feb 07 '15 at 19:04
well, I just found out something really disturbing... when I insert 5 objects = id 1-5...database is empty, but then if i try to insert it again, it throws an error... but in this situation, if i give id 6-10, there is no error again... does it mean im looking into wrong Database? but where is my database then? – sustekj Feb 07 '15 at 19:08
Yeah, look in your bin/debug folder – The One Feb 07 '15 at 19:09

Local database in Visual Studio wpf, data adding doesnt work

0 Answers0