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)

23 results for: 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...
c# c#-4.0 dapper expando expandoobject
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...
c#-4.0 crud dapper
asked by IamStalker

Dapper.NET documentation?

Where can I find the documentation on Dapper.net? There seem to be little if none! ...Thanks
c#-4.0 dapper tsql
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...
c#-4.0 dapper metadata sql-server-2008-r2 stored-procedures
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...
c#-4.0 dapper orm
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...
asp.net c#-4.0 dapper datareader dbdatareader
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...
c# c#-4.0 dapper
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...
c#-4.0 dapper orm
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..
asp.net-mvc-3 c#-4.0 dapper sql-server-2008
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...
c#-4.0 dapper mapping sqlclient sql-server-2008-r2
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...
c#-4.0 dapper generics
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...
async-await c#-4.0 dapper npgsql postgresql
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....
c# c#-4.0 dapper json.net servicestack
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...
c#-4.0 dapper sql sql-server visual-studio-2012
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...
.net asp.net-mvc c#-4.0 dapper generics
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. ...
bulkinsert c#-4.0 dapper dapper-extensions sql
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...
c#-4.0 dapper tsql
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
architecture c#-4.0 dapper sql-server-2008-r2
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...
c#-4.0 dapper sql sql-server
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...
c# c#-4.0 dapper sql-server sql-server-2000
asked by ondemand

Page 1 of 2
  • 1
  • 2
  • »

Prime Library

Performance

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

Expression Evaluator

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