using System;
using System.Data.SQLite;
using System.IO;
public class DatabaseCreation
{
static void Main(string[] args)
{
SQLiteConnection conexion;
SQLiteCommand cmd;
try
{
conexion = new SQLiteConnection
("Data Source=ejemplo01.sqlite;Version=3;" +
" New=True; Compress=True;");
conexion.Open();
if (!File.Exists("ejemplo01.sqlite"))
{
string creacion = "create table books ("
+ " title varchar(50), autor varchar(50)," +
" genre varchar(50), summary varchar(50))";
cmd = new SQLiteCommand(creacion, conexion);
cmd.ExecuteNonQuery();
}
string line;
string title = "",
autor = "",
genre = "",
summary = "";
do
{
Console.Write("Title: ");
line = Console.ReadLine();
if (line != null)
title = line;
Console.Write("Autor: ");
line = Console.ReadLine();
if (line != null)
autor = line;
Console.Write("Genre: ");
line = Console.ReadLine();
if (line != null)
genre = line;
Console.Write("Summary: ");
line = Console.ReadLine();
if (line != null)
summary = line;
string insercion = "insert into books values ('" + title +
"', '" + autor + "','" + genre + "', '" + summary + "')";
cmd = new SQLiteCommand(insercion, conexion);
cmd.ExecuteNonQuery();
Console.WriteLine("Insert OK!");
}
while (line != null);
conexion.Close();
}
catch (Exception e)
{
Console.WriteLine("Error" + e.Message);
}
}
}