lundi 15 juin 2015

How does System.Data.SQLite deal with .NET Data Types?

I'm struggling to find documentation around System.Data.SQLite's behaviour in regards to the various .NET data types.

For example, how does System.Data.SQLite store .NET Booleans in an SQLite database? There are several possible methods:

  • Integers 0 and 1
  • Integers 0 and –1
  • Text 'True' and 'False'
  • Text 'T' and 'F'
  • Text 'Y' and 'N'
  • etc...

And vice-versa – how are Booleans parsed out of SQLite? Does System.Data.SQLite expect a certain format? What is that format?

The lack of documentation around this is frustrating. Maybe I'm not looking in the right places?

Aucun commentaire:

Enregistrer un commentaire