title: sqlite database connection class in C#
body: <p>I am very new to C#, I am trying to create a sqlite database connection class. I have created a new class file by clicking on my project name> Add > Class. I have the following code in this file.</p>
  
  <p>The problem is I am getting error in every lines after <code>SQLiteDataReader</code> </p>
  
  <ol>
  <li>If I hover over <code>sqlite_conn</code> then it says '... is a field but is used like a type'</li>
  <li>if I hover over <code>SQLiteConnection</code> then it says ... method must have a return type</li>
  <li>If I hover over <code>("Data Source=database.db;Version=3;New=True;Compress=True;")</code> then it says Type expected</li>
  </ol>
  
  <p>` </p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Text;
  using Finisar.SQLite;
  
  namespace learningCsharp
  {
  class database
  {
      // We use these three SQLite objects:
      SQLiteConnection sqlite_conn;
      SQLiteCommand sqlite_cmd;
      SQLiteDataReader sqlite_datareader;
  
      // Getting error in every lines after this 
  
      // create a new database connection:
      sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;");
  
     //open the connection:
       sqlite_conn.Open();
  
     // create a new SQL command:
       sqlite_cmd = sqlite_conn.CreateCommand();
  
  }
  }
  </code></pre>
  
  <p>Could you please help me to solve this problem and create a working sqlite database connection class?</p>