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