I am new to the Dapper micro ORM. So far I am able to use it for simple ORM related stuff but I am not able to map the database column names with the class properties. For example, I have the following database table: Table Name: Person person_id int first_name varchar(50) last_name varchar(50) and I … Read more
How do I perform an insert to database and return inserted identity with Dapper? I’ve tried something like this: string sql = “DECLARE @ID int; ” + “INSERT INTO [MyTable] ([Stuff]) VALUES (@Stuff); ” + “SELECT @ID = SCOPE_IDENTITY()”; var id = connection.Query<int>(sql, new { Stuff = mystuff}).First(); But it did’t work. @Marc Gravell thanks, … Read more
I am very impressed with the results of Dapper Micro ORM for stackoverflow.com. I am considering it for my new project and but I have one concern about that some times my project requires to have Stored Procedure and I have search a lot on web but not found anything with stored procedure. So is … Read more
I am interested in using Dapper – but from what I can tell it only supports Query and Execute. I do not see that Dapper includes a way of Inserting and Updating objects. Given that our project (most projects?) need to do inserts and updates, what is the best practice for doing Inserts and Updates … Read more
What is the best way to write a query with IN clause using Dapper ORM when the list of values for the IN clause is coming from business logic? For example let’s say I have a query: SELECT * FROM SomeTable WHERE id IN (commaSeparatedListOfIDs) The commaSeparatedListOfIDs is being passed in from business logic and … Read more
