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
Asked
Active
Viewed 636 times
3
-
Why specifically sequences, what are you to use the for? Are you looking for a single integer column which auto-increments? Every database then supports that feature – Stephen Senkomago Musoke Jul 16 '12 at 06:12
-
1@ssmusoke: An auto_increment is something different than a sequence – Jul 16 '12 at 16:18
4 Answers
4
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)
-
Actually it would be DB2 Express-C (Express actually has a license cost). But DB2 does support sequences. We use sequences with DB2 Express-C where I work. – Chris Aldrich Jul 17 '12 at 12:40
-
@ChrisAldrich: thanks. I didn't know that there was a difference between Express and Express-C. – Jul 17 '12 at 12:54
-
3
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?
Leigh Riffel
- 23,854
- 16
- 78
- 152
0
SQL Server 2012 introduces sequences. You can download SQL Server 2012 Express for free, and the .NET integration should go without saying.
Thomas Stringer
- 42,224
- 9
- 117
- 154