System.Data.SQLite

CREATE TABLE [TB_User_GroupCalendar] (
[UserID] int  NOT NULL,
[GroupCalendarID] INT  NOT NULL,
FOREIGN KEY(UserID) REFERENCES TB_User(ObjectID),
FOREIGN KEY(GroupCalendarID) REFERENCES TB_GroupCalendar(ObjectID)

)

If I try to insert record with GroupCalendarID=777,  provided that no 777 exists in TB_GroupCalendar, I nevertheless, get my record inserted into TB_User_GroupCalendar. What I'm doing wrong and how to fix this?

 Sqlite does not have foreign key constraint support until 3.6.19.  You can enforce foreign key constraints prior to 3.6.19 via triggers.  Take a look at: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers

 Hope that helps!