I have a requirement that a database must support sequences. I know oracle and PostgreSQL support it. Are there any other free database software that support database sequences? it would be great if it had a .NET driver too
4 Answers
If with "free" you mean "open source", then Firebird comes to mind (but I personally would prefer PostgreSQL over it - the much better documentation alone is a reason).
Ingres also supports sequences, but I don't know if there is a .Net driver for it.
There are other open source ones like Apache Derby, HSQLDB and H2 Database but as they are Java only, I'm pretty sure they do not have a .Net driver
If with "free" you mean "free of charge", then Oracle Express, DB2 Express-C and SQL Server 2012 Express are an option as well (as all three of them support sequences)
Oracle Express Edition is free, supports sequences, and can integrate with .NET. See the question What features of Oracle make it an attractive choice for small projects?
- 23,884
- 17
- 80
- 155
SQL Server 2012 introduces sequences. You can download SQL Server 2012 Express for free, and the .NET integration should go without saying.
- 42,434
- 9
- 120
- 155