title: Basic Slick Insert Example
body: <p>Can anyone please help me with a basic Insert example using Slick 3.1.1.
  Database used is SQL Server.</p>
  
  <p>For a table named "employee" having columns "employee_id, name, start_date".</p>
  
  <p>This is how I defined the Employee Class:</p>
  
  <pre><code>class Employee(tag: Tag) extends Table[table_types.user](tag,  "EMPLOYEE") {
  
    def employeeID = column[Int]("EMPLOYEE_ID")
    def empName = column[String]("NAME")
    def startDate = column[String]("START_DATE")
  
    def * = (employeeID, empName, startDate)
  }
  </code></pre>
  
  <p>And this is what I wrote for creating the table and inserting data:</p>
  
  <pre><code>object Hello extends App {
  
    val db = Database.forConfig("test")
    val employee = TableQuery[Employee]
    db.run(employee.schema.create)
  
    try {
      val insert_action = DBIO.seq(employee += (1, "abc", "2016-01-01"))
      db.run(insert_action)
    }
    finally {
      db.close()
    }
  }
  </code></pre>
  
  <p>The table is created fine on the destination database but the row does not get inserted and there are no errors. Any help is much appreciated.</p>