I’m trying to replace most the stored procedures in our sql server database with code in our C# app, especially for simple data collection.
I looked for similar, previous posts and answers but I didn’t see anything recent so thought I’d pose the question again incase this is now in servicestack…
I have a fairly simple query:
SELECT a.*
FROM Table1 a
WHERE NOT EXISTS (SELECT NULL FROM Table2 b WHERE a.Id = b.Table1Id)
I’m struggling to type this into an efficient ORMLite query, that I’m happy with the resulting t-sql.
How should I go about this in ORMLite?