Dapper Tutorial - Knowledge Base (KB)
19 results in tag: ms-access
Dapper And System.Data.OleDb DbType.Date throwing 'OleDbException : Data type mismatch in criteria expression'
Not sure if I should raise an issue regarding this, so thought I would ask if anybody knew a simple workaround for this first. I am getting an error when I try to use Dapper with OleDbConnection when used in combination with MS Access 2003 (Jet.4.0) (not ...
asked by Lski
Dapper & MS Access - Read works, Write doesn't
Let's start by getting this out of the way: I'm stuck using an MS Access DB and I can't change it....This works fine:...using (OleDbConnection conn = ConnectionHelper.GetConnection()) { conn.Open(); var results = conn.Query<string>( "select FirstN...
asked by Trev
Dapper with MS Access Update and Insert issue
I am using Dapper to Update and Insert Access DB. Code is working not throwing exception but its not updating the value in DB. Below is my code...sql.Append("UPDATE drugs_repository SET drug_name = @DrugName "); sql.Append(" WHERE id = @DrugId"); var pa...
asked by techknackblogs
Run stored Microsoft Access action query with Dapper
As the title mentions, is there any way to run a stored Microsoft Access action query with Dapper? By action query I mean anything that doesn't return results (insert, update, delete)....I tried something like this but that would have been too easy I gues...
asked by Aetherix
Dapper splitOn not working
I'm trying to run a MS Access query with Dapper. I keep receiving the following error message: ...When using the multi-mapping APIs ensure you set the splitOn param if you have keys other than Id...This is the code I'm using:...IEnumerable<BalanceHeader> ...
asked by Aetherix
Dapper, MS Access, Integers and "no value given for one or more required parameters"
I keep getting the error "no value given for one or more required parameters" on the third attempt to insert in the code below. The first two attempts work fine. I'm running in .NET 4.0, against MS Access in VS 2012. And this problem appears to be consist...
asked by EDanaII
OleDbException on writing to MS Access using Dapper
I'm trying to do an insert with Dapper into my MS Access database, now querying the data works fine but when I do try an insert I get an ...System.Data.OleDb.OleDbException : Data type mismatch in criteria expression...The code is :...let conn = new OleDb...
asked by Overly Excessive
Dapper + MSAccess: How to get identifier of inserted row
I am using Dapper with C# and back end is MS Access. My DAL method inserts record in database. I want to return unique identifier (or updated POCO with unique identifier) of the inserted row. I am expecting my function something like follows (I know this ...
asked by Amit Joshi
Dapper Extension Ms Access System.Data.OleDb.OleDbException
I just started to use Dapper. Dapper works fine. As a next step when I tried to integrate with Dapper Extension. It generates an exception called System.Data.OleDb.OleDbException ..."Additional information: Characters found after end of SQL statement."...
asked by RobinAtTech
Dapper ORM Delete functionality with Access
Today when I was working with Access, I tried to do one test by changing one of the table name in Access but not updating in the code and trying to observe the behavior ...For example, My code is ...Product product = new Product(); ...
asked by RobinAtTech
Dapper 'Characters found after end of SQL statement.' - Stop Dapper returning identity value
I'm using Dapper with Microsoft Access (not by choice I assure you) and I'm also using the Dapper.Contrib extensions to allow me to do ...connection.Insert(address).... Unfortunately that's throwing an error ...'Characters found after end of SQL statemen...
asked by tomRedox
Update Query Does Nothing
I am trying to call the following query (parameters are in alphabetical order):...public const string UpdateSample = @"UPDATE subReceivingQC SET Clerk=@Clerk, Comments=@Comments, CommentsProd=@CommentsProd, GRV=@GRV, MassOff=@MassOff,...
asked by Bassie
Database does not accept decimal values in live
I am using the following bit of code to insert some data into a database: ...internal int InsertSample(Sample sample) { using (var db = new OleDbConnection(connectionString)) { var query = Constants.InsertNewSample; return db.Execu...
asked by Bassie
Dapper and access returning blank values
I'm trying to pull data from an Access database using dapper. I have the following class defined to use the fields from the access database that I need to read. I then tried to pull the data using the code below. When I run this only blanks come back. The...
asked by jrdnoland
Why Dapper does not UPDATE data to MS Access even though no exception?
I used the following code to update, but it is not working. The call is successful; there is no exception. But update does not reflect in database....When I change ...@id... to 2, it succeeds....OpenSqlConnection(); tm = new testmyy(); tm.ID = 2; tm.name...
asked by dongdong
"Must declare the scalar variable @Idx" when using a Dapper query on SQL server via OleDb
This code works when the connection is made to an accdb database:...Dim customer = connection.Query(Of Klantgegevens)("Select Actief,Onderhoudscontract From Klantgegevens Where Klantnummer=@Idx", New With {.Idx = customerId}).SingleOrDefault ...But the co...
asked by Dabblernl
Dapper.Contrib + MS Access: Error - Characters found after the end of the SQL statement
I am using Dapper ORM with the Contrib package. The ...SELECT... query works perfectly but my problem is when I try to ...INSERT... data....Visual Studio 2017 returns this message:...Characters found after the end of the SQL statement...The basic query ex...
asked by NBoulfroy
Dapper with Mapping by code: Multi-Mapping with repeating column names
I'm trying to perform a simple query and the result data is almost all ...null.......I have this table structure ...Table Registros...ID | Autonumeric TareaM_Id | Numeric Fecha | Date/Time ...and Macro_tareas table...ID ...
asked by Juan Salvador Portugal
How to insert multiple integer parameters into query?
Website user can enter search criteria to query orders. User, States, Status, OrderID, etc. ...Website communicates with API. Query parameters are in the header, so I assume they come in as strings. API communicates with Access via Dapper. ...For some ...
asked by BWhite
Page 1 of 1