Dapper Tutorial - Knowledge Base (KB)
23 results in tag: c#-4.0
how to convert Dictionary<dynamic, dynamic> to Dictionary<string, string> using Colllection.ToDictionary()
I am using Dapper to fetch a 2 column resultset into a dictionary. I noticed that intellisense shows me a .ToDictionary() when I hover over the resultset but I cannot get it to work since dapper uses dynamic properties/expandoObject...Dictionary<string, s...
asked by Gullu
Dapper and Oracle CRUD issues, how to?
How do i make Dapper.NET to CRUD my Oracle DB?...I have table named: ...PLAYER_LOG... it's identity is done by trigger, here is the sql...SELECT SQ_MASTER_SEQUENCE.NEXTVAL INTO tmpVar FROM dual; :NEW.ID := tmpVar; ...my Model is:...public class PlayerLogS...
asked by IamStalker
Dapper.NET documentation?
Where can I find the documentation on Dapper.net? There seem to be little if none! ...Thanks
asked by Bill
Using Dapper.Net ORM, how do I cast stored procedure output to a concrete type?
Using Entity Framework I can create concrete classes from most of the sprocs in the database of a project I'm working on. However, some of the sprocs use dynamic SQL and as such no metadata is returned for the sproc....So for a that sproc, I manually cre...
asked by ElHaix
How to get values for child objects using Dapper ORM?
I am retrieving profile details with the following:...var profiles = connection.Query<Models.PROFILE>( "SELECT * FROM PROFILES WHERE ID=@ID", new { ID = profileID }); // IEnumerable var profile = profiles.First<Models.PROFILE>(); ...The profile o...
asked by ElHaix
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...
asked by ElHaix
Dapper AddDynamicParams for IN statement with "dynamic" parameter name
I have simple SQL string like this:..."SELECT * FROM Office WHERE OfficeId IN @Ids" ...The thing is that the @Ids name is entered in an editor so it could be whatever, and my problem is that if I want to pass in, say an array of integers, it only works w...
asked by Jens Pettersson
Dapper does not warn or fail with missing data
Let's say I have a class (simplistic for example) and I want to ensure that the PersonId and Name field is ALWAYS populated....public class Person { int PersonId { get; set; } string Name { get; set; } string Address { get; set; } } ...Current...
asked by AboutDev
Cache solution for Dapper when using stored procedures (MSSQL)
I'm using ...Dapper... mainly for calling ...stored procedures... in the database ...MSSQL 2008 R2....I do not have classes that map to database tables. Most of the data ends up in ...IEnumerable <Dynamic>... and is transmitted to the grid on the screen..
asked by Tomasito
Error mapping dapper with an enum + sqlserver
I have a class:... public class Member { #region public property public int Id { get; set; } public string LastName { get; set; } public string FirstName { get; set; } public string Email { get; set; } public string Password { g...
asked by user1428798
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
AsyncQuery with postgresql and dapper using npqsql
I was trying dapper orm and recently they added asyncquery support. I googled it about that. It is wonderful if you have heavy traffic on your site. I was trying that with postgressql and dapper. Now, in connection if I am passing simple connection string...
asked by kunjee
How to return JSON not associative array
I'm writing simple API which returns array of JSON objects:...[ { "Id": 134649, "Type_id": 6, "Latitude": 56.904220, "Longitude":14.823440 }, { "Id": 134660, "Type_id": 6, "Latitude": 56....
asked by Ernestas StankeviÄius
Convert SQL Query to IList<T> using of Dapper
I use ...VS2012... and ...SQL Server 2012...I add ...Dapper... to my ...VS2012... like this...I have one class like this :... public class DomainClass { public SexEnum sex { get; set; } public int Id { get; set; } public str...
asked by Ardalan Shahgholi
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
Dapper - Bulk insert of new items and get back new IDs
I am using dapper to add multiple new students in one db hit using this method:...db.ExecuteAsync(@"INSERT Student(Name,Age) values (@Name,@Age)", students.Select(s => new { Name = s.Name, Age = s.Age }) ); ...But the problem I don't have the new ids. ...
asked by Yaron Levi
Combinations of Where Criteria - Still parameterized query - Dapper
I have a Dapper query as follows...Public void GetAllCusomers(string CustmoerId, StringFirstName, String LastName, String Gender) { TblCustomer tblCustomer = new TblCustomer(); using (var sqlConnection = new SqlConnection(“Database...
asked by Ganesha K
C# How to read ,validate multi tab excel sheet data and import in sql server tables
I need to upload ecommerce catalog data by reading data from multiple tabs And insert those data in SQL server tables....Whats best way to implement the same using c# and dapper .net and SQL server....Thanks Rakesh
asked by Rakesh Gaur
Bulk Insert in multiple relational tables using Dapper .Net-using scope identity
I need to import millions of records in multiple sql server relational tables....TableA(Aid(pk),Name,Color)----return id using scope identity TableB(Bid,Aid(fk),Name)---Here we need to insert Aid(pk) which we got using scocpe Identity ...How I can do bul...
asked by Rakesh
Net 4.0 with Dapper and Ms Sql 2000
As we know Ms Sql 2000 does not support MultipleActiveResultSets....Can i use Dapper with async Task without exceptions :..."There is already an open DataReader associated with this Command which must be closed first."...My code example...private async vo...
asked by ondemand
Page 1 of 2