What are the pros/cons of copying Dapper.cs into my project vs. using the dll instead vs. installing the nuget package?...This is an MVC4 project if that matters.
I am having following code...class Program
{
static void Main(string[] args)
{
static void Main(string[] args)
{
DapperExtensions.DapperExtensions.DefaultMapper = typeof(CodeCustomMapper);
string sql = "select UserID,Name as SName , ...
I've recently created a new project in MVC3 and connected a MySQL db to it without a problem. I'm able to create users and roles (using Universal Providers / SecurityGuard from NuGet). Now I'm trying to run a query using Dapper for my Edit page and get ...
Is there a way to remove the default dependency on Entity Framework within an ASP.NET MVC 4 project and replace it with another similar technology such as ...Dapper
I've recently been playing around with dapper, but I've run into a bit of a problem regarding getting data from other tables....My database has two tables, Users and Post. I've created two classes for these tables....My User class... public class User
{
...
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 ...
I'm tying to learn to use dapper....I have this class here:...public class Member_Collection : ObservableCollection<Member>
{
}
...and I have this method in my DAL class:... public static Member_Collection SqlSelectAll(string connString)
{
...
In my new project I am very confused between which ORMs to use.
Our database queries are very complex.
We are mainly stuck between Dapper and EF 5.
I know dapper has performance benefit and i think EF has its maintenance and code generation benefit....Bel...
My stored procedure is ...Create proc [dbo].[InsertPerson]
(
@LastName VARCHAR(64),
@FirstName VARCHAR(64),
@Age INT
)
AS
INSERT INTO Person Values(@LastName,@FirstName,@Age)
...The save method of the BaseRepository class is as follo...
I am trying to write a query to get a user in the system with all of his/her roles. There is a many-to-many relationship between users and roles. The joiner table is ...SystemUserUserRole... with columns ...UserId... and ...RoleId.... My models are bel...
I have a complex C# MVC 4 website that connects to multiple databases. Every request goes through the following steps...Check if user is signed in and get username from authentication cookie....Query a lookup database to figure out where the client's data...
I filled Drop Down List in MVC which is working fine but now I want to do it using Dapper but got stuck....DropDownList in MVC without Dapper...Controller... [HttpPost]
public ActionResult Create(User ur)
{
string str = @"Data Source=DEV_...
I am trying to populate dropdown list using ...Dapper... but when I am fetching the values from ...stored procedure...ID... is not getting fetched only name is getting fetched dont know where I am going wrong. Here is my Code...Controller...public ActionR...
I am using Dapper in my ASP.NET MVC 5 application and in my query I only want 2 fields to return but the Json returns all of the fields. This is my model... public class thread
{
[Key]
public int id { get; set; }
public int?...
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using Dapper;
namespace Calculate.Models
{
public class SelectedDetailsGetter
{
SqlConnection con = new SqlConnection("Data S...
Hi I am working on mvc as part of my learning, So I came accross a situation where I have to pass a datatable to the sp, along with the datatable I have to give one output parameter of ...int... also of the type. Currently I am using this code...con.Exec...