ÀÏ´Ü »ç¿ëÇÒ ÇÁ·ÎÁ§À¸¸¦ »ý¼º.
ÇÁ·ÎÁ§Æ® ¸íÀº ¿øÇÏ´Â ´ë·Î ¼³Á¤.
ÇÁ·ÎÁ§Æ®¸¦ »ý¼ºÇÑ ÈÄ, ´©°Ù ÆÐÅ°Áö °ü¸®ÀÚ·Î À̵¿ÇÑ´Ù.
ÆÐÅ°Áö °ü¸®ÀÚ¿¡¼ "sqlite" ·Î °Ë»öÇÏ¸é ¿©·¯°¡Áö ÆÐÅ°Áö°¡ °Ë»öµÈ´Ù. ÀÌ Áß¿¡¼ "system.Data.SQLite" ¶ó´Â À̸§ÀÇ ÆÐÅ°Áö¸¦ ¼³Ä¡ÇÑ´Ù. ºñ½ÁÇÑ ÆÐÅ°Áö°¡ Á¦¹ý ¸¹À¸¹Ç·Î Àß »ìÆ캻µÚ ¼³Ä¡ ÇÒ °Í.
Àú ÆÐÅ°Áö¸¦ ¼³Ä¡ÇÏ¸é °ü·Ã ÆÐÅ°Áöµéµµ ÀÏ°ý ¼³Ä¡µÈ´Ù.
ÆÐÅ°Áö°¡ ¼³Ä¡µÇ¸é ÀÚµ¿À¸·Î ÂüÁ¶¿¡ "System.Data.SQLite" °¡ Ãß°¡µÈ´Ù. ¸¸¾à ÀÌ ÂüÁ¶°¡ ÀÚµ¿À¸·Î ¼³Ä¡µÇÁö ¾ÊÀ¸¸é ÆÐÅ°Áö¸¦ À߸ø¼³Ä¡ÇÑ °ÍÀ̹ǷΠ´Ù½Ã È®ÀÎÇÏ°í ¼³Ä¡ÇØ¾ß ÇÑ´Ù.
ÂüÁ¶¿¡ Àú ÆÐÅ°Áö°¡ µî·ÏµÇ¾î ÀÖ¾î¾ß ÇÁ·ÎÁ§Æ® ³»¿¡¼ SQLite ÆÐÅ°Áö¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Ù.
sqlite °¡ Á¤»óÀûÀ¸·Î ¼³Ä¡µÇ¾ú´ÂÁö´Â "select sqlite_version()" ±¸¹®À» ½ÇÇà Çغ¸¸é ¾Ë¼ö ÀÖ´Ù.
º° ¹®Á¦°¡ ¾ø´Ù¸é create, insert, update ±¸¹®Àº "ExecuteNonQuery" ¸í·É¾î¸¦ »ç¿ëÇÏ°í select ±¸¹®Àº "ExecuteReader" ±¸¹®À¸·Î µ¥ÀÌÅ͸¦ Á¶È¸ ÇÒ¼ö ÀÖ´Ù.
¿¹Á¦¸¦ ½ÇÇà Çغ¸¸é ÄܼÖâ¿¡ DB ³»¿ëÀÌ Á¶È¸µÇ´Â°ÍÀ» º¼ ¼ö ÀÖ´Ù.
private void Form1_Load(object sender, EventArgs e)
{
string connStr = @"Data Source=C:\MyProg\DotNet\sqlite\mysqlite.db";
string stm = "SELECT SQLITE_VERSION()";
var con = new SQLiteConnection(connStr);
con.Open();
var cmd = new SQLiteCommand(con);
cmd.CommandText = @"CREATE TABLE cars(id INTEGER PRIMARY KEY, name TEXT, price INT)";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT INTO cars(name, price) VALUES('³»Â÷', 1000000)";
cmd.ExecuteNonQuery();
stm = "SELECT * FROM cars";
cmd = new SQLiteCommand(stm, con);
SQLiteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine($" ## {rdr.GetString(1)} / {rdr.GetInt32(2)}");
}
}
DB °æ·Î¸¦ ÁöÁ¤ÇØ ³õÀ¸¸é DB ÆÄÀÏÀÌ ¾øÀ» °æ¿ì ÀÚµ¿À¸·Î »ý¼ºÇØ ÁÖ´Ï ±ÄÀÌ µû·Î »ý¼ºÇÒ ÇÊ¿ä´Â ¾ø´Ù.