3

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

closed as off-topic by Philᵀᴹ, Taryn, Aaron Bertrand Jan 26 '15 at 14:48

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Philᵀᴹ, Taryn, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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 6:12
  • 1
    @ssmusoke: An auto_increment is something different than a sequence – a_horse_with_no_name Jul 16 '12 at 16:18
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. – a_horse_with_no_name Jul 17 '12 at 12:54
  • This compares Express vs Express-C as an fyi. – Chris Aldrich Jul 18 '12 at 12:52
3

Why don't you just use PostgreSQL then? It's great.

http://npgsql.projects.postgresql.org/

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?

0

SQL Server 2012 introduces sequences. You can download SQL Server 2012 Express for free, and the .NET integration should go without saying.

Not the answer you're looking for? Browse other questions tagged or ask your own question.