title: MS Access @@identity query issue
body: <p>Can someone please let me know the issue with the below query? I am running on MS Access and its giving </p>
  
  <blockquote>
    <p>Syntax error in query expression 'id = @@IDENTITY'</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>public DosageBO SaveDosage(DosageBO dosage)
  {
     try
     {
        using (IDbConnection connection = OpenConnection())
        {
           StringBuilder sql = new StringBuilder();
           sql.AppendLine("INSERT INTO dosage_master ( medicine_type, dosage, remarks, updateby, updatedate )");
           sql.AppendLine("VALUES (@type, @dose, @remarks, @updateby, NOW());");
  
           var parameters = new
                      {
                          type = dosage.MedicineType,
                          dose = dosage.Dosage,
                          remarks = dosage.Remarks,
                          updateby = Environment.UserName
                      };
  
           connection.Execute(sql.ToString(), parameters);
  
           return connection.Query&lt;DosageBO&gt;("SELECT medicine_type as MedicineType, dosage, remarks FROM dosage_master WHERE id = @@IDENTITY").FirstOrDefault();
        }
     }
     catch
     {
        throw;
     }
  }
  </code></pre>