What's the difference between Delete and Remove in a many-to-many relationship in CoolStorage
A many-to-many relationship has to methods to remove items: Delete and Remove. What is the difference between these two? ...
coolstorage
How do I order by NEWID in CoolStorage?
How can I order my resultset by NEWID to get a random order? ...
Vici.CoolStorage: filter with ManyToOne and ManyToMany relation
Hi, I got an exception in Vici.CoolStorage 'Unable to cast object of type 'System.String' to type 'QueryExpression' when using the following filter on the .List() method of my Event class: Event.List("has(Resource where has(Teams where TeamID = @TeamID))", "@TeamID", teamID); -> Event - Resource = ManyToOne relation ...
Sorting on nullable child property in CoolStorage
Lets says we have Films and HeaderItems. Sometimes a Film has a HeaderItem linked to it OneToOne but not always. Now I want to sort all the Films on their title BUT I would like the films with a HeaderItem linked to them to sort on HeaderItem.Position (if HeaderItem is not null). I've tried to implement a OneToMany on Films and a OneTo...
how do i execute a stored procedure with vici coolstorage?
I'm building an app around Vici Coolstorage (asp.net version). I have my classes created and mapped to my database tables and can pull a list of all records fine. I've written a stored procedure where the query jumps across databases that aren't mapped with Coolstorage, however, the fields in the query result map directly to one of my c...
Searching many-to-many relations with Vici CoolStorage
For an application used for managing booktitles and such, I'm using CoolStorage as an ORM. The database has a table named 'titles'. Each title can have n authors, stored in the 'authors' table. The two tables are connected through the linktable 'titles_authors', which is pure. When I try to filter titles on authors, I get an exception:...