Can I use anything other than BIGINT as Primary Key data type in SQLite?

Posted by weenet on Stack Overflow See other posts from Stack Overflow or by weenet
Published on 2010-06-08T20:37:46Z Indexed on 2010/06/08 20:52 UTC
Read the original article Hit count: 160

Filed under:

I was psyched about the possibility of using SQLite as a database solution during development so that I could focus on writing the code first and dynamically generating the db at runtime using NHibernate's ShemaExport functionality. However, I'm running into a few issues, not the least of which is that it seems that SQLite requires me to use Int64 for my primary keys (vs, say, Int32 or Guid). Is there any way around this?

© Stack Overflow or respective owner

Related posts about sqlite