Dapper Tutorial - Knowledge Base (KB)
65 results in tag: entity-framework
Increase performance on query with a lot of one-to-many mappings
I'm using Entity Framework to SQL Azure and in one page of my application we show quite a bit of related data to the user. We're loading a max of 30 items on the page but each item has 5 one-to-many mappings to other objects. The query time is at a reason...
asked by BZink
EF to ADO.NET transition
Need suggestion for migration few modules of asp.net mvc 3 application: Right now we are using EF with POCO classes, but in the future for some performance driven modules we need to move to ADO.NET or some other ORM tool (may be DAPPER.NET)....The issue w...
asked by Burhan Farooq
Relax or disable table constraints when using Dapper and Entity Framework?
I would like to set a do something like this ...dataSet1.EnforceConstraints = false;... using the Dapper.Net ORM and Entity Framework....I created the models in VS2010 where a property:... [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable...
asked by ElHaix
Performance of Entity Framework 5 compared to ServiceStack Orm lite
EF5 was released a week ago and should have improved performance quite a bit. I am currently using ServiceStack OrmLite but am considering swithcing to EF5 because it also allows CodeFirst + it has a migrations feature....The benchmarks I have found howev...
asked by ssn
'Table name' could not be resolved in the current scope or context
I saw a similar question to this, but it involved field names and not the table name issue I'm having....I'm trying to do a simple pull from one of my tables, but I'm encountering an error that I just can't figure out....The error message states: ...'Stud...
asked by aokelly
A combination of Entity Framework, Dapper and SSDT?
I'm in the early stages of setting up a new development project and I'm unsure how to set up my database access strategy. I'll be using Visual Studio 2012 and I'll target .NET 4.5 and SQL Server 2008 or 2012. ...What I'm unsure about is whether or not to ...
asked by JulianR
Custom atomic UPDATE commands inside SaveChanges()
For various reasons I need to be able to do several custom SQL ...UPDATE... commands when I call ...SaveChanges... on a ...DbContext.... I want this to happen atomically so either both the regular ...SaveChanges... and the SQL succeeds, or neither does...
asked by JulianR
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
Is there a way to remove the default dependency on Entity Framework within MVC 4?
Is there a way to remove the default dependency on Entity Framework within an ASP.NET MVC 4 project and replace it with another similar technology such as ...Dapper
asked by Mantzas
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
Can I use dapper-dot-net with Entity Framework?
I am trying to use ...dapper-dot-net... to speed up some area of my asp.net mvc application. I am using EF5 Code first also....Since dapper-dot-net is just some extensions for IDbConnection, can i just use ...DbContext.Database.Connection ...to use dapp...
asked by liuhongbo
EF 5 benchmarks
I'm following the ...performance test... that Dapper community created....Currently, I'm getting the following after run the tests 10000 times:...EF 5 = 21595 ms...ADO.NET = 52183 ms...Dapper = 52499 ms...iBatis = 83138 ms...I need that something help me ...
asked by Augusto Pedraza
How to capture all SQL sent over Ado.Net
I have an application that uses both Entity Framework and Dapper. I would like to provide a custom logger to log out any sql that is issued over the ado.net connection. What is the best way of doing this?...Alternately, if it's not easily possible what ex...
asked by George Mauer
What are the main criteria while choosing between different ORMs
In my new project I am very confused between which ORMs to use. Our database queries are very complex. We are mainly stuck between Dapper and EF 5. I know dapper has performance benefit and i think EF has its maintenance and code generation benefit....Bel...
asked by Vishwajeet
Cannot map SQL Geography column to EF DbGeography class with dapper
I have table with sql geography column in my SQL database. I have generated entities for my database with EF6. As you know Entitiy Framework generates ...System.Data.Entity.Spatial.DbGeography... for SQL Geography type. I'm using dapper to run queries and...
asked by Mkrtich Mazmanyan
Why can I have multiple data readers with Dapper but not Entity Framework?
I started developing an application using ...Dapper... but decided that for some queries it would be nice to use Entity Framework. So I'm in the process of refactoring some of my queries. In the Dapper-only days, I had some code similar to this:...foreach...
asked by Phil
Get best performance of Entity Framework 6 like Dapper.NET
I used dapper.net as micro-orm, speed and performance is fantastic ! ...Simple CRUD Operations in Dapper is more quickly than Entity Framework 6....Speed-Comparison-Dapper-vs-Entity-Framework...But if I want speed and performance of Entity Framework 6 ...
asked by Hamed F
Latest Dapper VS Entity Framework 6 performance considerations
There are a few performance comparisons between Dapper (which seems to be the fastest, most popular "micro ORM tool"). Now it's September 2014 and we have Entity Framework 6 (not 5, or 4) and Dapper is still around....We will begin developing a huge datab...
asked by John
Dapper: Mapping dynamic pivot columns from stored procedure
My stored procedure is returning dynamic pivot columns as available. I am using the SQLMapper and COlumnTypeAttribute, But in the results I can only see the first column and its value, but the dynamic pivot column(s) and their values(s) are empty....the s...
asked by user721
Page 1 of 4