ODBC Connection

OdbcRepository.cs

public class OdbcRepository
{
  public List<Model> Get(string name)
  {
    //Create a connection
    var connection = new OdbcConnection(connectionString);
    
    //Construct the query
    //Usually you use @parameter as the syntax for querying SQL Server
    //But for querying to Microsoft Access you must use ?
    var queryText = "SELECT * FROM table1 WHERE Name = ?";
    
    //Use dapper to query with parameter
    //It's also a good idea if you use a string as a parameter that you use DbString instead of sending the variable directly
    //You will also need to specify the Length exactly as the length of the column in the Microsoft Access table
    var data = connection.Query<Model>(queryText, new { Name = new DbString { Value = name, Length = 10, IsAnsi = true } });
    
    return data.ToList();
  }
}