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)

105 results for: in tag: asp.net-mvc

Matching multiple classes with dapper

How can I retrieve this objects with Dapper? For example:...public class ClassA { public int Id { get; set; } public string Text { get; set; } public ClassB b { get; set; } public ClassC c { get; set; } public ClassD d { get; set; } ...
asp.net-mvc asp.net-mvc-3 dapper
asked by Matías Romero

Reset Cache for Dapper

Is there a way to reset the cache that ...Dapper... generates? I dropped a table column in my database, and I got the error "column not found." I reset IIS and it worked fine after that....Can this be reset without restarting IIS? Thanks.
asp.net-mvc c# dapper
asked by SaltProgrammer

Dapper, ODATA, and IQueryable in ASP.NET

I saw the great performance of Dapper and some samples of how to use it....I was wondering if I can use it to provide IQueryable data and integrate it with UI layer using ODATA to transfer data to the UI (like grids, lists,...)....Is there any way to retu...
asp.net-mvc dapper iqueryable mvvm odata
asked by Amir Pournasserian

What's the best architecture for a medium-sized, high traffic web site?

I'm starting a new project (non-corporative) and I want to know how would be a great architecture nowadays....What I'm planning for now is to use: ...ASP.NET MVC 4.0...SQL Server 2008 or 2012...EF 5.0 under .NET 4.5, with Dapper...Implementation of Reposi...
architecture asp.net-mvc dapper entity-framework performance
asked by eduardobr

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

Passing DTO to my ViewModels constructor to map properties

In my solution I have two projects....Project 1 (Core) Mapping SQL to DTO using Dapper...Project 2 (WebUI - ASP.NET MVC 4) Here I use a ViewModel per View....Examples of a Controller... [HttpGet] public ActionResult Edit(int id) { // Get ...
architecture asp.net-mvc c# dapper
asked by Nils Anders

entity vs. dapper datetime check not worker

I have entity and also use dapper, I have 1 form with 2 date fields... named ...before... and ...after... so users can search in between those dates. The one from entity works perfectly but the one from dapper does not work for some reason what could poss...
asp.net-mvc dapper entity-framework
asked by user1591668

Need Help in applying SOLID principles

Really impressed with Juile Lerman's pluralsight course on "EF in Enterprise" and decided to build my demo app....I am using VS 2012 and latest versions of EF,SQL Server and MVC. I am building a demo application which applies SOLID principles. I am doing ...
asp.net-mvc dapper entity-framework n-tier-architecture oop
asked by NoobDeveloper

Repository vs Service pattern in DAL: EF and Dapper

I'm working on project and I need to design the DAL. I will be using ...Entity Framework... for most of the project and ...Dapper... for some performance-sensitive areas. ...I was thinking about using the Repository pattern but then EF already implements ...
asp.net-mvc dapper design-patterns entity-framework
asked by nomad

Using multiple database schema in a multi tenant application

I am moving my current application to a multi tenant architecture. With a single code base, i need to address multiple tenants. I am using single database, multiple schema approach. Each tenant will be assigned a separate schema with the meta data saved i...
architecture asp.net-mvc dapper multi-tenant
asked by Rifaj

Dapper: Not able to parse floats (Error parsing column)

I am retrieving data from SQL Server from a StoredProcedure using Dapper and I'm getting error...Specified cast is not valid....and details: ...Error parsing column 4 (SubTotal=0.00 - Decimal)...On SQL Server side the column ...SubTotal... is ...decimal(1...
asp.net-mvc dapper sql-server
asked by nomad

Dapper: Method not found: 'System.Collections.Generic.IEnumerable`1<!!0> GridReader.Read(Boolean)'

I'm looking to swap some EF code-first db requests for Dapper to speed up some sluggish parts of our Web site. I've only just started experimenting, and Dapper seems fine....I've successfully converted some code to use the .Query extension. But now I'm tr...
.net asp.net-mvc c#-4.0 dapper generics
asked by Steve Owen

Conversion between IEnumerable to IList (Dapper return result)

There is signature of ...UserManager... method (ASP .NET Identity Core default implementation):...public Task<IList<string>> GetRolesAsync(User user) { const string query = @" select r.[Name] from [UserRoles] ur ...
.net asp.net-mvc c# dapper
asked by Maxim Zhukov

Sorting db info for MVC model

FindByCounty()... This function should go out to the db and pull the information. Store the information in their respective classes (which it does)...but then what?...public EditCountyViewModel FindByCounty(string countyName) { var par...
asp.net-mvc c# dapper mysql
asked by MaylorTaylor

Could not load file or assembly 'Dapper, Version=1.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies

I am unable to solve this problem, ..."System.Exception : Could not load file or assembly 'Dapper, Version=1.8.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."...I have check the references...
asp.net-mvc c# dapper
asked by user865660

How create query with multiple LIKE-s that does not create memory issue in dapper cache?

I'm using Dapper to work with sql database. I have some search logic in my website project....My search gets list of string parameters....//filter is list of strings var sql = new StringBuilder(); sql.Append("SELECT LibraryDocumentId FROM LibraryDocument...
.net asp.net-mvc c# dapper sql
asked by Mkrtich Mazmanyan

update N rows with performance considerations

I have a table with OrderSequence, the schema looks roughly like this:...id...Name...OrderSequence...I have an arrays of ids ("1", "2", "3", "4") in my MVC Action codes, i want to set the SequenceOrder for sorting purpose. I don't want to loop it via .Net...
asp.net-mvc c# dapper sql-server
asked by Lee Gary

Use a IDBConnection in a service

On an MVC project I have a service layer with commands and queries....In some of these commands and queries I use Dapper which needs a Connection....public class GetPostsStatsQuery { public GetPostsStatsQuery() { } public PostStats Execute() { ...
asp.net-mvc c# dapper
asked by Miguel Moura

Adding parameters to a query with Informix and Dapper fails with syntax exception

I'm attempting to use parameterized queries with Informix over ODBC, but any attempt to add parameters fails with this exception:...$exception {"ERROR [42000] [Informix .NET provider][Informix]A syntax error has occurred."} System.Exception {IBM.Data.I...
asp.net-mvc c# dapper informix
asked by Ben

Generic dapper QueryMultiple function

I am using asp.net mvc, dapper and MySql stored procedures for my web app. So far, for each page I have 1-3 stored procedures calls. I recently found out my hosting only provides 10 parallel connections and so I want to combine my calls into one per page....
asp.net-mvc c# dapper generics
asked by shahaf

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

Prime Library

Performance

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

Expression Evaluator

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