Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this 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 –  ssmusoke Jul 16 '12 at 6:12
    
@ssmusoke: An auto_increment is something different than a sequence –  a_horse_with_no_name Jul 16 '12 at 16:18
add comment

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)

share|improve this answer
    
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
    
@ChrisAldrich: thanks, very helpful. –  a_horse_with_no_name Jul 18 '12 at 13:06
add comment

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

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

share|improve this answer
add comment

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?

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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