Dapper Tutorial - Knowledge Base (KB)
1868 results for:
Add Dapper to Enterprise Library?
We are using the Enterprise Library as a standard DAL. Now, I would like to enjoy the benefits of Dapper. Looking at the implementation it is just extending the connection class....Is it conceivable to set Dapper to extend Enterprise Library so we can enj...
asked by Ron Harlev
How to use ormlite with SQL Server and Mars?
ServiceStack aficionados, hello!...We are legion (I hope so), so please help a brother out :)...I am trying to populate two collections with one SQL Server 2008 stored procedure call that return two resultsets. I have "MultipleActiveResultSets=True" in my...
asked by Mister Arrazan
Dapper Column number rather than column name?
I have a very similar question to ...Dapper-dot-net "no column name"..., but the answer there is not getting me where I need....I'm writing a web interface and using dapper to get data from Stored Procedures from my client's ERP system. The SP returns 4 c...
asked by studiothat
InvalidCastException when using Dapper to map a Date field from MySql
I am just getting started using Dapper to access a MySql database and I seem to be running into an issue when dealing with date fields. Any time I try to map a MySql Date type field I am receiving an invalid cast. It seems that the MySql connector is re...
asked by Mickey
Replacements to hand-rolled ADO.NET POCO mapping?
I have written a wrapper around ADO.NET's DbProviderFactory that I use extensively throughout my applications. I also have written a lot of code that maps IDataReader rows to POCOs. However, as I have tons of classes the whole thing is getting to be a pai...
asked by ScottD
Implementing a Lightweight TransactionScope
I'm referring to this SO question: ...Bulk inserts taking longer than expected using Dapper...and to this @SamSaffron comment to that question:..."TransactionScope does a bunch of DTC nonsense you generally do not care about, would avoid it unless I neede...
asked by Felice Pollano
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
Does Dapper work in medium trust?
Just getting started with Dapper. I'd like to use it, but I have to be sure that it will work in a medium-trust server situation. I've googled for answer without any luck....Thanks.
asked by r.l.parker
Dynamic resultset with dapper on 3.5
I've got a store procedure call returning a recordset whith field unknown in advance. For some interop reason I need to make it working on 3.5, so I don't have any dynamic support. Is there some built-in solution in dapper? I did not find any by myself. ...
asked by Felice Pollano
How to return null from a Dapper query rather than default(T)?
I'm using ...Dapper... for some read-only database calls via a stored procedure. I've got a query that will either return 1 row or nothing....I'm using Dapper like this:...using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); retu...
asked by James Simm
Generalize Dapper query within a delegate, Func or Action C#
I have several kind of a ...Dapper... queries like this below, with several different types as result. This is one specific from these, which produce e.g. List<ClassA> :...string anSql = GetSqlQueryText("query_name"); SqlConnection connection = GetSqlConn...
asked by Tomcat14
Dapper.net use query into the Dictionary
my sql is :...select (select count(*) from TblRMember where sex=1) male, (select count(*) from TblRMember where sex=2) female, (select count(*) from TblRMember where sex=0) unkown ...I want Dapper.Net to return a Dictinary like this:...Keys:male,female,...
asked by zt9788
Dapper to DataTable
I have a scenario where I need to return a ...DataTable... from a query using Dapper. How do I return a ...DataTable... from a query using Dapper?...DataTable dt = connection.Query("SELECT * FROM table");
asked by user2421145
Report Viewer X Dapper
I'm feeding a ...ReportDataSource... with a query using Dapper. However, I have an empty report, even with an ...IEnumerable... loaded data. When you spend a ...Datatable... works....How do I pass data from a query using Dapper for ...ReportViewer...?...t...
asked by user2421145
Attempting to Modify Dapper to Support SQL Server CE's ntext type
I have a need to support SQL Server CE's ...ntext... type in Dapper. There is a thread here describing the issue: ...https://code.google.com/p/dapper-dot-net/issues/detail?can=2&start=0&num=100&q=&colspec=ID%20Type%20Status%20Priority%20Milestone%20Owner%...
asked by John
Dapper multiple objects from one row
I have one row coming from the database...select "John" Name, "Male" Gender, 20 Age, "Rex" PetName, "Male" PetGender, 5 PetAge // ... many more ... ...Using Dapper, I'd like to pull this row into two objects:...c...
asked by Jay Sullivan
HttpContext.Current.Cache VS. SQL Table Performance
We have a poorly designed shopping cart database. All processed objects that will be used to the front site are stored in HttpContext.Current.Cache on ...Application_Start.... Processed objects I mean results from sql script that has many joins and where ...
asked by peng
Performance of Insight micro-ORM
I was wondering if anybody has some metrics on Insight micro-ORM. Its a fairly new ORM, like Dapper but more for stored procs.
asked by Dkong
Dapper Order By Parameters
This is a follow-up to this question:...Dapper Order By...Since parameterization doesn't work in the order by clause with Dapper, what is the recommended method of keeping bobby tables at bay? Does Dapper provide some way to clean these parameters, or is...
asked by GhostOfPerdition
Dapper & Oracle Clob type
I am using dapper to do some oracle access. I have a scenario where I have to have an output parameter with a type of OracleDbType.Clob. As I am using dapper and thus using the base DbType enumeration I am using the DbType.Object enum as suggested here ...
asked by Jon
Page 4 of 94