Most voted "dapper" questions
Dapper is a class database object mapper for . NET which basically acts as an extension of the Idbconnection interface.
Learn more…58 questions
Sort by count of
-
14
votes2
answers225
viewsWhat is Fastexpando/Fastexpandoobject?
Was reading about Dapper and I came across a feature of him called Fastexpando or Fastexpandoobject, I didn’t understand very well and I had some doubts about this feature. Doubts What is…
-
11
votes3
answers1813
viewsHow to map 1:N (one to many) in Dapper?
I’m using the Dapper which is a micro ORM used to map objects according to the database tables following the relational model. Therefore, I have some doubts regarding the mapping and the structure…
-
8
votes1
answer6294
viewsMultiple INNER JOINS with DAPPER
I’m trying to accomplish multiple INNER JOIN in the Dapper with these classes: public class EventoConfiguracao { public EventoConfiguracao() { //CdEventoConfiguracao = Guid.NewGuid(); Menus = new…
-
7
votes3
answers6315
viewsHow to make an "Insert" with Dapper using a class?
I’m testing Dapper and when I try to use a class I found the error: Must declare the scalar variable Follows the code: public class Teste { public int id; public string nome; public int idade; }…
-
5
votes1
answer283
viewsFill Combobox with Dapper
I’m using a component of combobox with the Dapper, but I’m not able to fill the combobox properly, follow code excerpt: LookUpEdit ctlControle = (LookUpEdit) pr_Controle; var parametro = new…
-
5
votes2
answers1283
viewsSELECT 3 different tables using DAPPER?
First I would like to say that I am a beginner in programming, and I am in developing my first project. Using ASP.NET MVC Technology. I need to make a query in 3 different tables: User, Parents and…
-
5
votes2
answers1346
viewsDifference between ADO.NET and Dapper
What are the differences between Orms? When to use one and when to use the other? What are the disadvantages of each?
-
4
votes1
answer274
viewsError in Dapper query
Well, I’m trying to perform a consultation on Dapper and get the following error: The model item inserted in the dictionary is of type'System.Collections.Generic.List`1[Taxability…
-
4
votes1
answer672
views.Net Core, Dapper and Visual Studio Code?
I’m trying to integrate Dapper into the. Net Core, but I’m not getting and all the tutorials I found, were made in Visual Studio, using Nugget. Then someone could explain me how to import Dapper…
-
4
votes1
answer2880
viewsHow to Perform Procedures with Dapper
How can I run a store with Dapper?
-
4
votes2
answers220
viewsHow to map and obtain only one property or field of a query?
I’m using the Dapper that has the purpose of map properties of objects. See a practical example: var servico = conexao.Query<Servico>(statement.ToSql(), new { IdServico = id }).First(); That…
-
4
votes1
answer359
viewsUsing EF and Dapper in the same project
I’m making a simple insert of a user class, it is taking almost 10 seconds to record the information. So I tried to find other solutions to solve my performance problem and found the Dapper. My…
-
4
votes1
answer823
viewsWhat is the purpose of Concurrencystamp and Securitystamp in ASP.NET Identity?
The summary of both properties in the entity IdentityUser are in English: Concurrencystamp: A Random value that must change Whenever a user is persisted to the store. Translating would be something…
-
3
votes2
answers120
viewsEnumeration class in the Repository Pattern
How can I read from my bank an attribute int which in my system is a type attribute Enumeration in the Repository Pattern? I took a class: public class Status : Enumeration { public static readonly…
-
3
votes2
answers86
viewsORM that can connect with 2 BD types (SQL or HANA)
Any suggestion of a ORM or Micro ORM that can connect/manipulate 2 different database types, not Imultaneos? The scenario: I already have an application that uses SQL, I need to adapt it to accept…
-
3
votes1
answer285
viewsFill Grid dynamically with Dapper framework return
I have a screen written in VB.NET Winforms, where the goal of it will be to execute SQL commands without the need to open a sql studio. For simpler commands like delete, update, alter table among…
-
3
votes1
answer3537
viewsDynamic mapping error: Missing type map Configuration or Unsupported Mapping
I have a data dictionary something like this: public class Colunas { public string ColunaOrigem {get; set;} public string ColunaDestino {get; set;} public DbType Tipo {get; set;} } public class…
-
3
votes1
answer39
viewsIs there any way to run an event whenever the Sqlconnection.Update method of Dapper.Contrib.Extensions runs on an entity?
I’ve been using Dapper for a short time and so I have little experience with it. I wonder if there is any way to detect changes in a specific field. I need this because in a given table, every time…
dapperasked 6 years, 6 months ago Wallace Maxters 102,340 -
3
votes1
answer246
viewsSelection with Dapper using IN clause
My idea is to generate a search in my bank using the clause in through the Dapper. For example: select * from product where CasNo in(@filtro) Remembering that inside this @filtro has a list of Casno…
-
2
votes1
answer1166
viewsDapper Framework Error: Could not load file or Assembly 'Dapper, A strongly-named Assembly is required
Hello, I use Dapper Framework to perform my SQL queries in C# Windows Forms, and recently started a new project, and came across this error: Could not load file or Assembly 'Dapper,…
-
2
votes2
answers487
viewsTake only the return value in a Dapper
A query returns this? var teste = _connection.Query(sQuery.ToString(), par).FirstOrDefault(); well, within the var test I have it: UF = "MA" but I just want the MA. How do I make Dapper return me…
-
2
votes1
answer694
viewsMult Mapping Dapper
I am having problems with Mult Mapping of Dapper, when I try to execute the following query is not mapping the object ids select is this: var sql = @" SELECT ofi.id_oficina, ofi.codigo, p.id_pedido,…
-
2
votes1
answer820
viewsReturn int in a select using Dapper.
I need to return the idCity. If it is not found in one table, it is obligatory in the other. The return is nil. My Query public const string sql = @"DECLARE @retorno AS INT = 0; SELECT @retorno = id…
-
2
votes1
answer77
viewsHow do I verify that all data on my list exists in the database?
I need to take the files that are in a list and compare with the files that are in a table in the database, and know if the amount of files that is in my list is the same amount as the table. using…
-
2
votes2
answers271
viewsDapper requires writing SQL code, why?
I’m looking at the following link that uses Dapper: Getting Started With Postgresql Using Dapper In . NET Core and my question is, when I do Java I don’t need to write SQL code as this example here:…
-
2
votes0
answers189
viewsGeneric Repository with Dapper
I’m doing a test application where I want to see performance and learn about creating a generic repository with Dapper, well I have some experience when creating a generic repository, but using EF6,…
-
2
votes0
answers80
viewsHow to map entity using Dapper with postgres
I’m having a big challenge here and I can’t seem to solve it. I’m working with DDD and on the layer of Infra esotu using Dapper When trying to execute the following code on RepositorioUsuario:…
-
2
votes0
answers77
viewsProblem running a function in Asp.net.core.webapi + postgresql + npgsql+Dapper
I have a Webapi in Asp.net core, using postgresql as a database. Inside postgresql, I have the following function: CREATE OR REPLACE FUNCTION evento_distancia( IN lat numeric, IN lng numeric, IN…
postgresql asp.net-web-api asp.net-core dapper npgsqlasked 5 years, 6 months ago Thiago Oliveira 147 -
1
votes1
answer462
viewsHow to use Generic Method with Dapper?
I have 2 methods from a generic repository public TEntity ObterPorId(int id) { return Db.Set<TEntity>().Find(); } public IEnumerable<TEntity> ObterTodos() { return…
-
1
votes0
answers866
viewsHow to list data with Inner Join with mvc 5, c#, Dapper, and sql server?
I’m having the following difficulties: 1 - Data display from a select with Inner Join. The fields of the other tables do not appear all that are in select, and the ones that appear, have the value…
-
1
votes0
answers87
viewsSpecifications and Dapper
Hello, does anyone know any extension of dapper that makes it possible to use Specifications (Expression<Func<T, bool>>) in c#?
-
1
votes1
answer167
viewsError Running a query with npgsql + Dapper in postgresql
I can capture my "user" object that has inside of itself a "Login and a Password" and, when executing the function by my ORM, I catch the following error message: {"42883: operator does not exist:…
-
1
votes1
answer691
viewsASP NET MVC 5 Dapper with SQL Server?
I’m creating an app with ASP.NET MVC5, DAPPER, C# And SQL SERVER. The problem, is that in the data listing, is bringing the empty fields, except the ID field, which comes zero (0). If anyone knows…
-
1
votes1
answer198
viewsControl time to return timeout
Look at the scenery: I have a procedure that running directly by SQL it takes about 50s to return the data. However, when this same process is executed via the system, the timeout in 15 s. My…
-
1
votes1
answer47
viewsAccess to EF Core data
Doubt access to data efcore I have a table with many fields, I’m using EF Core for access, it is possible to return only the fields that I will actually use? Ex. in a listing, precise ID and Title,…
-
1
votes1
answer417
viewsHow to pass a list of integers as Dapper parameters?
I am trying to pass a parameter which is a list of integers, this should be attached to query in the sql server IN clause, but I’m not sure how to use it with DAPPER. I tried to do it this way. var…
-
1
votes1
answer154
viewsProblem changing entity with E.F and Dapper
I have a Dapper query, where I search for an entity: var fatura = ObterPorClientedEDataVencimento(cobranca.ClienteId, cobranca.DataCobranca); The method and properties of my entity are in this Gist,…
-
1
votes2
answers119
viewsSQL connection to Dapper/Asp.net Core
I’m starting in Asp.net Core and I’m having difficulties to connect my Sql database. Below is my Model My class of connection appsetting.json startup.Cs Controller Error shown when trying to execute…
-
1
votes1
answer223
viewsHow to run a MERGE object list by returning the Update or Insert Id?
I have the following scenario; I need to make a INSERT or UPDATE from a list of List<PRD_ARTIGO_VARIANTE_VALOR>, my doubt is whether there’s any way I can get past the list of a single time by…
-
0
votes1
answer909
viewsHow to map the return of a Value Object with Dapper?
Hello! I have a question related to the return of an object with an already filled 'Value Object', example: I have the User.Cs class. public class User { public Guid UserId { get; set; } public…
-
0
votes1
answer281
viewsHow to use parameters in the sql query using Dapper?
How can I make a simple select using Dapper and passing more than one parameter? Method: public IEnumerable<Locais> ConsultarPorTermo(string termo) { const string sql = @"SELECT * FROM Locais…
-
0
votes0
answers8
viewsuse Dapper with txt file and not database
greetings as I can use the Dapper with a text file and not a table or database, need to manipulate and change several lines of this text. I have a form where I open a txt on a datagrid with multiple…
-
0
votes2
answers84
viewsWays of connection in ASP . NET
I’m a beginner in ASP and C#. I have doubts and this is the real reason to ask here. Before you have to read the politics of questions understand that I am a beginner and I really need help. I have…
-
0
votes1
answer77
viewsSqlite in memory with Dapper generates non-existent table error
I have the following code for table creation: string query = @"CREATE TABLE GVP_USERS_TAGS( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT, DATEINS datetime NOT NULL DEFAULT (DATETIME('now')), NAME…
-
0
votes0
answers337
viewsInner Join problems on Dapper
I have the following problem, when I make a Inner Join in 3 tables the Dapper does not bring me all the columns of the 3 tables but only the one of my father table Inner Join ( or is the first table…
-
0
votes0
answers106
viewsDapper in 1-1 grating where in class there is no foreign key
When working with ORM it is common (Will it be mandatory?) to create the model classes as if they were a mirror of the tables of the bank. But I have a different case and I was wondering if Dapper…
-
0
votes1
answer25
viewsGlimpse ASP.Net working with Dapper
I just saw a piece of content where I studied performance and optimization in ASP.Net applications. I was presented with a diagnostic tool called Glimpse. The operation of the tool is perfect, it…
-
0
votes1
answer204
viewsControl Dapper Transaction with Simplecrud / Error: Enlisting in Ambient transactions is not supported
Good morning guys, all right? I need to control the Dapper transaction using Simplecrud. I have an application in Asp.net core using Dependency Injection. I will post parts of the code only…
-
0
votes1
answer98
viewsProblem with accentuated character in the return of the query
I have a Mysql database with encoding defined as latin1_swedish_ci. I’m using Dapper to connect the database. When I make a query to certain tables, the characters that are accented comes as follows…
-
0
votes0
answers50
viewsPass datatable to storedprocedure with Dapper . net core
I have a proc with the following parameters @TabelaIdsCompras TipoTabelaIdGenerico READONLY, @TabelaIdsProds TipoTabelaIdGenerico READONLY And I have my datatables: DataTable tableIdsProd= new…