Passing query parameters in Dapper using OleDb

by

The following should work:

var result = conn.Query(
"select code, name from mytable where id = ?id? order by name",
new { id = 1 });

More Related Contents:

  1. Microsoft.ACE.OLEDB.12.0 provider is not registered
  2. Manually map column names with class properties
  3. OleDbCommand parameters order and priority
  4. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  5. Fastest way to perform nested bulk inserts with scope_identity() usage?
  6. Reading excel file using OLEDB Data Provider
  7. OleDbParameters and Parameter Names
  8. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  9. How do I map lists of nested objects with Dapper
  10. Is there a way to call a stored procedure with Dapper?
  11. Does Dapper support SQL 2008 Table-Valued Parameters?
  12. How to implement Generic Repository Design Pattern with Dapper?
  13. Dapper.NET and stored proc with multiple result sets
  14. Parsing CSV using OleDb using C#
  15. Searching values via a datagridview
  16. Trying to insert DateTime.Now into Date/Time field gives “Data type mismatch” error
  17. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  18. How do I perform an insert and return inserted identity with Dapper?
  19. How can I import an Excel file into SQL Server? [closed]
  20. Bulk inserts taking longer than expected using Dapper
  21. Optimal way to Read an Excel file (.xls/.xlsx)
  22. Closing connection when using Dapper
  23. How do I handle Database Connections with Dapper in .NET?
  24. Is there any way to trace\log the sql using Dapper?
  25. Is there a “proper” way to read CSV files [duplicate]
  26. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  27. Dapper and anonymous Types
  28. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  29. Why Entity Framework performs faster than Dapper in direct select statement [closed]
  30. Does Microsoft OLE DB Provider for SQL Server support TLS 1.2

Leave a Comment