zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

19 results for: 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 ...
dapper ms-access oledbconnection
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...
ado.net c# dapper ms-access oledb
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...
c# dapper ms-access
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...
c# dapper ms-access
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> ...
c# dapper ms-access ms-access-2010
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...
c# dapper ms-access oledb visual-studio-2012
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...
dapper f# ms-access 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 ...
c# dapper ms-access
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."...
dapper dapper-extensions ms-access
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(); ...
c# dapper ms-access
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...
dapper ms-access petapoco
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,...
asp.net-mvc c# dapper ms-access orm
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...
asp.net-mvc c# dapper ms-access
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...
c# dapper ms-access oledb
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...
dapper ms-access sql
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...
dapper ms-access oledb sql-server-express
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...
c# dapper dapper-contrib ms-access
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 ...
c# dapper ms-access orm
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 ...
api dapper ms-access
asked by BWhite

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...