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)

68 results for: in tag: postgresql

PostgreSQL, problems with Boolean type storing values as "T" and "F" breaking ORM

If I define a boolean data type in a Postgres table and query from it, the results for the boolean columns come back as "t" or "f"....I'm using NPGSQL as my driver and Dapper as a ORM. This causes a problem because Dapper is unable to convert "t" or "f" i...
dapper npgsql postgresql
asked by Jonathan Holland

Does Dapper work on Mono?

We're thinking about moving over to ...Mono... and I see that ...Dapper... works with MySql. However this is with a ADO.NET provider. Does Mono/Linux have a MySql ADO.NET provider and does that work with Dapper?...Eventually we are planning on moving our ...
c# dapper mono mysql postgresql
asked by thames

Dapper stored procedures with Postgresql without alphabetical parameters

I am trying to call a Postgresql stored procedure written in plpgsql using C# and Dapper, but I have found that Dapper alphabetizes the parameters before inserting them into the stored procedure. Is there a way I can avoid this behavior and have the items...
c# dapper plpgsql postgresql stored-procedures
asked by CookieOfFortune

How Do I Change the Dialect in Dapper Extensions?

By default, the RDBMS dialect for dapper extensions is SqlServer. How do I change this to another dialect?...I've figured I can do: (I'm just quickly throwing together a pgsql dialect)... var conf = new DapperExtensionsConfiguration(typeof(AutoClassMapper...
c# dapper postgresql
asked by M K. Price

AsyncQuery with postgresql and dapper using npqsql

I was trying dapper orm and recently they added asyncquery support. I googled it about that. It is wonderful if you have heavy traffic on your site. I was trying that with postgressql and dapper. Now, in connection if I am passing simple connection string...
async-await c#-4.0 dapper npgsql postgresql
asked by kunjee

How to read DateTimeOffset from Postgres with Dapper.net?

Having this Postgres table...CREATE TABLE "TimeRange" ( "Id" bigint NOT NULL, "Start" timestamp with time zone NOT NULL, "End" timestamp with time zone NOT NULL, CONSTRAINT "TimeRange_pkey" PRIMARY KEY ("Id") ) ...Filling it with...INSERT INTO "Ti...
dapper datetimeoffset postgresql
asked by sa.he

dapper sql in-clause throws exception

This may be a duplicate of ...SELECT * FROM X WHERE id IN (...) with Dapper ORM...I am trying to achieve :...connection.execute("delete from table where id in @ids", new { ids = new int[]{1,2}}); ...But it's not working. I always get : ERROR: 42883: opera...
dapper in-clause postgresql sql
asked by user3448717

Calling a stored procedure with Dapper and Postgres

I have been trying to call a Postgresql stored procedure using Dapper and every example I have seen has the same thing but for some reason it is not working for me. It seems like it is calling the stored procedure but it never returns any results. This is...
c# dapper postgresql stored-procedures
asked by GBreen12

PostgreSQL missing operator when using IN predicate with string array

Given this table structure:...CREATE TABLE tags ( id SERIAL NOT NULL PRIMARY KEY, tagname TEXT NOT NULL UNIQUE, authorid int NOT NULL, created timestamp NOT NULL, lastmodified timestamp NOT NULL, constraint fk_authorid_tags foreign key(author...
c# dapper npgsql postgresql
asked by Oliver Weichhold

Issue with inserting null value array property using Dapper and Npgsql2

I'm currently investigating a problem with executing an insert using Dapper's Execute in conjunction with the Npgsql2 managed provider for PostgreSQL 9.3....Table Structure (simplified):...CREATE TABLE posts ( id SERIAL NOT NULL PRIMARY KEY, title TEX...
c# dapper npgsql postgresql sql
asked by Oliver Weichhold

Dapper parameters not working with PostgreSQL through npgsql connection, is postgres anonymous function parameterization supported?

I'm trying to use dapper to parameterize a postgres anonymous function i've written to do an upsert. Here's the code:...private static int UpsertProductPrice( IDbConnection connection, Data.ProductPrice price, List<Data.ProductPric...
c# dapper npgsql postgresql
asked by Perry R

Npgsql 3.0.0 Fails to Parse Enumerated Types

I have enumerated types in Postgres, defined as follows:...CREATE TYPE "SomeEnumType" AS ENUM ( 'Val1', 'Val2' ); ...I have the equivalent enum defined in C#:...public enum SomeEnumType { Val1, Val2 } ...When I updated to Npgsql v3.0.0, de...
c# dapper npgsql postgresql
asked by Jeff G

Npgsql 3.0.0 Chokes on Queries with Parameters that have Custom Type Handlers in Dapper 1.42

This issue appears to be with something in Npgsql 3.0.0 that changed from under Dapper 1.42. I came to that conclusion since the following code used to work when using Npgsql 2.2.3 with the same version of Dapper:...public struct MyStruct { private r...
c# dapper npgsql postgresql
asked by Jeff G

"ERROR: 57014: canceling statement due to user request" Npgsql

I am having this ...phantom... problem in my application where one in every 5 request on a specific page (on an ASP.NET MVC application) throws this error:...Npgsql.NpgsqlException: ERROR: 57014: canceling statement due to user request at Npgsql.Npgsql...
command dapper npgsql postgresql
asked by gyosifov

"WHERE x IN y" clause with dapper and postgresql throwing 42601: syntax error at or near \"$1\"

I have an array of strings, and I'd like to have a query containing an IN clause, like:..."... WHERE t.name IN ('foo', 'bar', 'baz')..>" ...Here's the final bit of my query, which contains a "where X in Y" clause:...... left join genre_tag_band_join tj on...
asp.net-mvc c# dapper npgsql postgresql
asked by Sava B.

Insert Multiple Values and Return Multiple Values

I've just started using Dapper and I've run into the following problem....I want to insert a bunch of records, and return the inserted records alongside the auto-incremented id....Using Postgres, I want to run the equivalent of this query:...INSERT INTO p...
c# dapper postgresql sql
asked by janderson

How to get Dapper to ignore/remove underscores in field names when mapping?

There are many ways to map database field names to class names, but what is the simplest way to just remove the underscores?... public IEnumerable<PersonResult> GetPerson(int personId) { using (var dbConnection = _dbConnectionFactory.Create...
dapper mapping postgresql
asked by scw

Questions about Dapper SQL queries and parameters with PostgreSQL

I´m currently learning about Dapper. I have searched a lot here and other places (including ...this...) and I could not find concrete answers to my doubts:...¿Does Dapper use a generic SQL dialect or it's specific for DB engine? I mean, it uses the SQL ...
c# dapper dialect postgresql sql
asked by AlighaThor

Dapper and Npgsql throws exception by use EXPLAIN with IN-clause and List<int>

I try to fetch an execution plan from Postgresql via Npgsql and Dapper....And versions of used software.....Net Framework 4.6.1...ASP.NET WebAPI 2...Postgresql 9.4...Npgsql v3.0.5...Dapper v1.42.0...Non-EXPLAIN query with IN-clause with List<int> can fetc...
c# dapper npgsql postgresql
asked by t2k

Dapper Contrib Insert MatchNamesWithUnderscores mapper isn’t working

The ...Dapper.DefaultTypeMap.MatchNamesWithUnderscores... isn’t working for inserts. The mapper works fine for the ...Get<>... method. I'm using the follow versions in my ASP.NET Core 1.0 RC2 project together with postgres database...."dependencies": { ...
c# dapper dapper-extensions micro-orm postgresql
asked by stevo

Page 1 of 4
  • 1
  • 2
  • 3
  • 4
  • »

Prime Library

Performance

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

Expression Evaluator

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