Yes, that is the problem: How to do this with entity framework? Entity framework does all the class making from the model (ORM). great tool. But I find it weird that nobody has stumble upon this problem. I cannot find a conclusive answer on this. you know: NO(, It is not possible. because[...] . or it will be possible in the next build) YES(, override this and this and there you go)
all the answer are vague on the matter or left alone. So that is why I'm here. ________________________________ From: "Duquette, William H (318K)" <william.h.duque...@jpl.nasa.gov> To: David Richardson <daviric...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thursday, October 4, 2012 11:57 AM Subject: Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working On 10/4/12 8:26 AM, "David Richardson" <daviric...@yahoo.com> wrote: Yes, I've read about it. I try to implemented it but it did not seem to work. I even read somewhere that you can add this to the connectionstring but no luck with them. > > >I tried all these solutions: >http://stackoverflow.com/questions/2477872/problem-with-cascade-delete-using-entity-framework-and-system-data-sqlite > >http://stackoverflow.com/questions/7674318/cascade-on-delete-not-cascading-with-ef > >http://stackoverflow.com/questions/4981353/how-to-enable-foreign-key-cascade-delete-by-default-in-sqlite > > > >But none of these worked. Either I'm implementing it wrong or there is a bug. >So i was expecting an out-of-the-box solution to this issue. So do you have an >working example on how to do this the right way? I just eval "PRAGMA foreign_keys = ON" as soon as I open the connection, and the cascading deletes in the schema all take place as expected. However, I'm not using Entity Framework 4 or anything like it; there's evidently something else going on. Will >________________________________ > From: "Duquette, William H (318K)" <william.h.duque...@jpl.nasa.gov> >To: David Richardson <daviric...@yahoo.com>; General Discussion of SQLite >Database <sqlite-users@sqlite.org> >Sent: Thursday, October 4, 2012 10:39 AM >Subject: Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working > >On 10/4/12 7:29 AM, "David Richardson" <daviric...@yahoo.com> wrote: > > >>I¹m having some sort of >>bug with system.data.sqlite. I¹ve been trying for weeks now! I¹ve >>installed (System.Data.SQLite 1.0.81.0) and >>i¹m using sqlite in combination with Entity Framework 4. Mostly it does >>what I >>want. The only problem I¹m having is that when I try to delete it should >>cascade , but 'on cascade delete¹ does NOT work. I change >>the connectionstring to SQL Server 2008 instance and entity framework >>works >>perfect! So there is something missing here. Or am I doing something >>wrong? > > >Have you enabled foreign keys using the "foreign_keys" pragma? This >currently needs to be done each time you connect to the database. > >Will >-- >Will Duquette -- william.h.duque...@jpl.nasa.gov >Athena Development Lead -- Jet Propulsion Laboratory >"It's amazing what you can do with the right tools." > > > > > > > > > > >> >>I cannot find any >>information on the internet on how to do this with system.data.sqlite >>properly. >> >>Is this a bug? >>_______________________________________________ >>sqlite-users mailing list >>sqlite-users@sqlite.org >>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
