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)

88 results for: 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?
asp.net c# dapper mysql
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 ..
asp.net c# dapper mapping
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...
asp.net dapper orm sql-server-2008
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...
asp.net c# dapper orm
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?
asp.net c# dapper sql-server
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?
asp.net c# dapper mysql
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...
.net-4.0 asp.net dapper securityexception shared-hosting
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...
asp.net c#-4.0 dapper datareader dbdatareader
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...
asp.net dapper design-patterns oop sql
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...
asp.net dapper orm petapoco
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...
ado.net asp.net asp.net-mvc c# dapper
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...
asp.net c# dapper
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...
asp.net c# dapper
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 ...
asp.net dapper orm simple.data sql-server-2008
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", ...
asp.net c# dapper
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...
asp.net c# dapper
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...
asp.net c# dapper
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...
ado.net asp.net c# dapper sqldatareader
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...
asp.net c# dapper micro-orm sql-update
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...
ado.net asp.net dapper glimpse
asked by maartendekker

Page 1 of 5
  • 1
  • 2
  • 3
  • 4
  • 5
  • ยป

Prime Library

Performance

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

Expression Evaluator

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