microsoft tech club cairo university "mstc'16 builders and developers " session #8
Post on 23-Jan-2017
233 Views
Preview:
TRANSCRIPT
Agenda
-What is database?-Basic queries of database
-Connect your universal application with SQLite-Let’s try
Create
CREATE TABLE table_name(Column_Name1 datatype (size),Column_Name2 datatype (size),
.
.
.
.Column_Name3 datatype (size);)
Insert
INSERT INTO table_nameVALUES (value1,value2,….);ORINSERT INTO table_name
(column1,column2,column3)…,VALUES(value1,value2,value3,…);
Select
SELECT column_nameFROM table_nameWHERE your_condition;OR
SELECT* FROM table_nameWHERE your_condition;
Operators
=Equal > <Not equal <Less than
>Greater than =>Greater than or equal
=<Less than or equalLike Search for pattern
Connect your universal application with SQLite
First press tools then open updates and extensions, make sure that these 2 extensions are available
Connect your universal application with SQLiteThen from solution explorer right click on References and choose Add reference
Repeat the previous steps on the Windows phone 8.1 part
Connect your universal application with SQLite
Connect your universal application with SQLiteYou will notice these warnings in windows and windows phone
Connect your universal application with SQLite
To solve this warnings open Configuration Manager fromDebug and choose x86
Connect your universal application with SQLiteRight click on your project from solution explorerand choose Manage nugget packages and install SQLite-net
Connect your universal application with SQLiteTo make sure that everything is going right you will notice appearance of this 2 classes in windows and window phone part
top related