Dapper Tutorial - Knowledge Base (KB)
88 results in tag: asp.net
Read/Write distribution over MySQL Master/Slaves using Dapper
Would dapper have any problems with using two IDbConnection objects for distributing Writes and Reads between MySQL Master/Slaves?
asked by Kynth
Unexpected behaviour with a multi-mapping query using Dapper.net
I've only just started looking at Dapper.net and have just been experimenting with some different queries, one of which is producing weird results that i wouldn't expect....I have 2 tables - ...Photos... & ...PhotoCategories..., of which are related on ..
asked by marcusstarnes
Dapper.net transaction problem
I'm trying to commit a transaction to my Sql Server 2008 database - firstly 2 insert's followed by a couple update's, however, as soon as it attempts to execute the first of the update's, I get the following error:...ExecuteNonQuery requires the command t...
asked by marcusstarnes
Recommended asp.net MVC model design approach
I'm trying to decide the best approach for a new project I'm about to start on, when it comes to my model design (and I'm using Dapper.net)....I like the idea of having my models with objects rather than Foreign Key properties, i.e....public Post LastPost...
asked by marcusstarnes
How to get a bigint to a long object property from SQL Server using Dapper?
I have a ...bigint... in my table and when I try to do a select using Dapper, it is not working. I found a tip that said to cast to numeric, but that is throwing a invalid cast error....What is the correct cast to use with dapper?
asked by jpshook
Accessing Mysql using dapper
I am new to .NET. I am interested in using the Dapper micro-ORM to access a MySQL backend from an ASP .NET application. ...Can this be done? What do I need to know to get started?
asked by Learner
SecurityException - Dapper on shared hosting
For my current project I use Dapper. Everything perfect. Then I needed to deploy it on shared hosting. The result can be seen here (copied YSOD):...Description: The application attempted to perform an operation not allowed by the security policy. To gr...
asked by stej
Open DataReader issues while using Dapper.Net in high traffic scenario - now to resolve?
Here is an example of one of our data calls in our DAL using Dapper.Net:... /// <summary> /// Handles db connectivity as Dapper assumes an existing connection for all functions /// Since the app uses three databases, pass in the connection stri...
asked by ElHaix
C# database access, Dapper, SQL and POCOs - programming design
Let's say we have a table in SQL represented in C# like this:...public class Product { public int ID { get; set; } public string Name { get; set; } public string Picture { get; set; } // filename of the picture, e.g. apple.jpg public int Categ...
asked by walther
Dapper vs Petapoco - Easy data access in ASP.NET 4.5 Web Application
I want to use an ORM with my new ASP.NET 4.5 project. I am developing my project with Visual Studio 2012. I want to know what are the advantages of using various ORM products, including the following:...Entity Framework (seems the slowest)...Dapper (seems...
asked by Idan Shechter
Dapper or ADO.NET when faced with tables with no primary key constraints
In reference to this post ...Using ASP.Net MVC with Classic ADO.Net...I wanted a bit of help regarding building an MVC application using a database that I have ...no access to change..., which has tables with ...no primary keys... and some with no discern...
asked by Pricey
IDbConnection factory using Dapper
I using dapper in my ASP.NET WebForms solution....All my classes which handles data retrieves an open connection from this base class...public abstract class SalesDb : IDisposable { protected static IDbConnection OpenConnection() { IDbConn...
asked by Nils Anders
How to map to a Dictionary object from database results using Dapper Dot Net?
If I have a simple query such as:...string sql = "SELECT UniqueString, ID FROM Table"; ...and I want to map it to a dictionary object such as:...Dictionary<string, int> myDictionary = new Dictionary<string, int>(); ...How would I do this with Dappe...
asked by jpshook
Which of these is better practice for CRUD? Simple.Data or Dapper?
I'm using both Dapper and simple.Data in my application, Dapper for retrieving data only and other operations by Simple.Data. I just need to know if using Simple.Data is better approach in all operations except retrieval and is it the same in performance ...
asked by omab
Is there a Dapper executenonquery? How do I know if my update worked?
So I have a simple update using Dapper:... using (var conn = new SqlConnection(myConnectionString)) { conn.Open(); conn.Execute("UPDATE Orders SET Exported=1 WHERE ManufacturerID=@ManufactuterID AND OrderID=@OrderID", ...
asked by Slee
How to limit parameters passed using Dapper's DynamicParameter constructor
Using the Dapper DynamicParameters constructor, is there a way to exclude certain parameters from being included. For example, say I have the following entity,...public class EntityA { public string Method1 { get; set; } public string Method2 { g...
asked by user1790300
Chaining multiple classes with dapper
I have two class for example...class User { string name {get;set;} int age {get;set;} Register reg {get;set;} } class Register { datetime time {get; set;} bool active {get;set;} } ...I have the query set up to match the properties but I want to...
asked by James Andrew Smith
Sqldatareader optional parameter
I have a datareader that is getting results from my stored procedure. The stored procedure depending on certain values such as ("ismarried" = true) returns 10 coulmns but if ("ismarried" = false) it returns only 5 columns....In my asp.net page my dataread...
asked by Tim
Unable to run update statement using Dapper (parameters error)
I am trying to update a row using Dapper but I am having error on specifying parameters in my update statement...An exception of type 'System.InvalidOperationException' occurred in IBM.Data.DB2.iSeries.dll but was not handled in user code Additional infor...
asked by Zo Has
Some questions concerning the combination of ADO.NET, Dapper QueryAsync and Glimpse.ADO
I have been experimenting with a lightweight solution for handling my business logic. It consists of a vanilla ADO.NET connection that is extended with ...Dapper..., and monitored by ...Glimpse.ADO.... The use case for this setup will be a web application...
asked by maartendekker
Page 1 of 5