sqlite is in fact the best solution for c# aurora
4 reasons
* sqlite is the fastest db available (yes, even faster than mysql)
* no need for installing a database server (for all other db-systems like mysql, postgres, oracle this is mandatory), only a dll is needed.
* very easy sql dialect, recursive cte´s are possbile
* sqlite is public domain
i´m working >17 years with access, sqlite and ms-sql and sqlite is by far the easiest one. the sql-syntax is very gentle and you can do things easy, which are not possible in ms-ssql or jet-sql
* i. e. you can "group by" a column which is in the select a aggregate with the "AS" keyword and there is no need to rewrite the complete aggreate, the alias is enough
* you can group by a single column and there is no need to enumerate all other columns from the select statement like ms-ssql it forces, because this is complete pointless -the result doesn´t
canges after the first grouped column
* recursive cte´s. it´s fantastic. i had a sql-query which builds a tree of items and the longest runtime was appr. 30 seconds. after the rewrite to recursive variation the runtime was 4 seconds!
tenim