Cov txheej txheem:

Kuv yuav ntxiv SQLite rau Visual Studio 2017 li cas?
Kuv yuav ntxiv SQLite rau Visual Studio 2017 li cas?

Video: Kuv yuav ntxiv SQLite rau Visual Studio 2017 li cas?

Video: Kuv yuav ntxiv SQLite rau Visual Studio 2017 li cas?
Video: Quas Koj Ntxhais Rau Kuv Tub - Cai Hawj Feat. Maiv Xis Vaj「Official MV」 2024, Hlis ntuj nqeg
Anonim

Ntxiv SQLite /SQL Server Compact Toolbox los ntawm Hauv Visual Studio 2017 Zej Zog. Goto Tools - Extensions thiab Hloov Kho - nyem Online. Nrhiav rau Sqlite . Koj yuav tsum pom Sqlite compact toolbox.

Kuj nug, kuv yuav ntxiv SQLite rau Visual Studio li cas?

Yuav Ua Li Cas Txuas Visual Studio LightSwitch rau SQLite

  1. Tsim ib qhov project LightSwitch tshiab.
  2. Nyem Txuas mus rau cov ntaub ntawv sab nraud thiab xaiv Database nyob rau hauv lub thawv tso tawm.
  3. Xaiv SQLite hauv daim ntawv teev cov ntaub ntawv, xaiv dotConnect rau SQLite nyob rau hauv cov ntaub ntawv muab kev pab cuam nco-down daim ntawv teev, thiab nias lub pob txuas ntxiv.

Tom qab ntawd, lo lus nug yog, Kuv yuav ua li cas thiaj tsim tau lub database hauv SQLite? Tsim Cov Ntaub Ntawv Tshiab

  1. Ntawm lub plhaub lossis DOS sai, nkag mus: "sqlite3 test. db". Qhov no yuav tsim ib lub database tshiab hu ua "test. db". (Koj tuaj yeem siv lwm lub npe yog tias koj nyiam.)
  2. Nkag mus rau SQL cov lus txib ntawm qhov kev hais kom tsim thiab populate cov ntaub ntawv tshiab.
  3. Cov ntaub ntawv ntxiv muaj nyob ntawm no.

Kuj kom paub yog, Kuv yuav rub tawm SQLite li cas?

Yuav ua li cas rau nruab SQLite3

  1. Mus rau SQLite3 download nplooj ntawv, "Precompiled Binaries For Windows" seem;
  2. Rub tawm "sqlite-plhaub" thiab "sqlite-dll" cov ntaub ntawv khaws cia;
  3. Unpack lawv nyob rau hauv C: WINDOWSsystem32 nplaub tshev (los yog lwm yam uas yog nyob rau hauv koj PATH);
  4. Nruab sqlite3 Ruby lub pov haum.

Kuv yuav qhib SQLite database li cas?

SQLite thaub qab & Database

  1. Nkag mus rau "C: sqlite" nplaub tshev, tom qab ntawd ob npaug nyem rau sqlite3.exe qhib nws.
  2. Qhib cov ntaub ntawv siv cov lus nug nram qab no.open c:/sqlite/sample/SchoolDB.db.
  3. Yog tias nws nyob hauv tib phau ntawv uas sqlite3.exe nyob, ces koj tsis tas yuav qhia qhov chaw, zoo li qhov no:.open SchoolDB.db.

Pom zoo: