Microsoft Data Sqlite
- SQLite Tutorial
- Advanced SQLite
- SQLite Interfaces
Hi, I am Startup for C# with Sqlite database. I develop a small project it'll collect customer details in Windows forms. I try to connect Sqlite in my C# form but i didn't know how to insert the values to my sqlite database. Microsoft.Data.Sqlite Namespace. Represents a SQL statement to be executed against a SQLite database. Represents a connection to a SQLite database. Provides a simple way to create and manage the contents of connection strings used by SqliteConnection. Provides methods for reading the result of a command executed against a SQLite database. Hi, I work on a project hosted on PI3 running Windows 10 IoTCore v10.0.14939.448. I add the new EntityFrameword 7 package: Microsoft.EntityFrameworkCore.Sqlite and Microsoft.EntityCore.Tools all working good on x86 local test. But when compiling and running on Pi3 Windows IOT I got this exception: 'System.DllNotFoundException' in Microsoft.Data.Sqlite.dll.
- SQLite Useful Resources
- Selected Reading
SQLite data type is an attribute that specifies the type of data of any object. Each column, variable and expression has related data type in SQLite.
You would use these data types while creating your tables. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with its container.
SQLite Storage Classes
Each value stored in an SQLite database has one of the following storage classes −
| Sr.No. | Storage Class & Description |
|---|---|
| 1 | NULL The value is a NULL value. |
| 2 | INTEGER The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value. |
| 3 | REAL The value is a floating point value, stored as an 8-byte IEEE floating point number. |
| 4 | TEXT The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE) |
| 5 | BLOB The value is a blob of data, stored exactly as it was input. |
SQLite storage class is slightly more general than a datatype. The INTEGER storage class, for example, includes 6 different integer datatypes of different lengths.
SQLite Affinity Type
SQLite supports the concept of type affinity on columns. Any column can still store any type of data but the preferred storage class for a column is called its affinity. Each table column in an SQLite3 database is assigned one of the following type affinities −
| Sr.No. | Affinity & Description |
|---|---|
| 1 | TEXT This column stores all data using storage classes NULL, TEXT or BLOB. |
| 2 | NUMERIC This column may contain values using all five storage classes. |
| 3 | INTEGER Behaves the same as a column with NUMERIC affinity, with an exception in a CAST expression. |
| 4 | REAL Behaves like a column with NUMERIC affinity except that it forces integer values into floating point representation. Phone Tricks, Tips, Hacks, And Secrets. In the phone tricks, tips, hacks, and secrets category, you will find an abundance of helpful information that all cell phone users can benefit from. Whether you have an Android phone or an iPhone you will learn some new tips, tricks, and secrets that you can use in. Modern cell phones can do so much more than just calls, including tricks that you would not suspect. Did you know there is a secret way to use your cell phone as cell phone spy? This is just one example of hacks that can be performed with your cell phone. Check out our cell phone tricks and tips. Cell phone tricks and hacks. Jul 18, 2017 How to Hack Wi-Fi Passwords. 15 Cool Tricks You Didn't Know Your Phone's Camera Could. Most people don't really need to know how their local cell. |
| 5 | NONE A column with affinity NONE does not prefer one storage class over another and no attempt is made to coerce data from one storage class into another. |
SQLite Affinity and Type Names
Following table lists down various data type names which can be used while creating SQLite3 tables with the corresponding applied affinity.
| Data Type | Affinity |
|---|---|
| INTEGER |
| TEXT |
| NONE |
| REAL |
| NUMERIC |
Boolean Datatype
SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
Date and Time Datatype
SQLite does not have a separate storage class for storing dates and/or times, but SQLite is capable of storing dates and times as TEXT, REAL or INTEGER values.
| Sr.No. | Storage Class & Date Formate |
|---|---|
| 1 | TEXT A date in a format like 'YYYY-MM-DD HH:MM:SS.SSS' |
| 2 | REAL The number of days since noon in Greenwich on November 24, 4714 B.C. |
| 3 | INTEGER The number of seconds since 1970-01-01 00:00:00 UTC |
Microsoft.data.sqlite.dll Download
You can choose to store dates and times in any of these formats and freely convert between formats using the built-in date and time functions.