Dapper Tutorial - Knowledge Base (KB)
23 results for: in tag: c#-4.0
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
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
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
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
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
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
How Do I Build a Dynamic Where Clause with Dapper when Passing in a Model
I have an example model that looks like this:...public class PersonModel { public int Id {get; set;} public string FirstName {get; set;} public string Lastname {get; set;} public string City {get; set;} } ...In my repository I want to ...
asked by Eldorian
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
Insert into 120 columns from 120-indexed array
I have column names like this...Id ,Test ,[H01_1] ,[H01_2] ,[H01_3] ,[H01_4] ,[H01] ,[H02_1] ,[H02_2] ,[H02_3] ,[H02_4] ,[H02] ,[H03_1] ,[H03_2] ,[H03_3] ,[H03_4] ,[H03] ,[H04_1] ,[H04_2] ,[H04_3] ,[H04_4] ,[H04] ,[H05_1] ,[H05_2] ,[H05_3] ,[H05_4] ,[H05]...
asked by LearningJrDev
How to Sort data according to Order by clause using DESC order in dapper extensions?
I want to sort data in DESC order. This is my code:...var predicate = Predicates.Sort<myPoco>(x => x.name, false); var result = GetList<myPoco>(predicate).ToList(); protected IEnumerable<T> GetList<T>(object predicate, IList<ISort> sort = null, IDbTransa...
asked by PNG
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 - 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
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
Page 1 of 2