Dapper Tutorial - Knowledge Base (KB)
93 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; } ...
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.
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...
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...
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...
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 ...
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...
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 ...
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 ...
asked by erdinger
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...
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...
asked by erdinger
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...
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 ...
asked by FSou1
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...
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...
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...
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...
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() { ...
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...
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....
asked by shahaf
Page 1 of 5