|
I've used Dapper a few times. I really like it and as others have said it generally gets out of the way and works well at mapping your sql to an object or collection of objects.
I use it with Dapper extensions which makes simple selecting/updating etc pretty simple.
I invested a lot of time in learning EF and it was hard to make the move but honestly I've never found a need to go back to using EF. EF seems overly complex, at least for my needs and I fail to see a good reason for using EF over a micro orm like Dapper or PetaPoco (which i also like).
|
|
|
|
|
I use it.
We wrote a slightly bigger ORM thing to go on top of it: Dashing[^]
And yes, much time was spent on the name.
|
|
|
|
|
I've been using Dapper's spinoff NPoco for a couple of years in a large work project and it's worked out mostly great.
The good:
1. Lightning fast, just a fraction slower than bare-bones ADO.NET.
2. No surprise SQL, you know exactly what SQL is sent to the server because you wrote it yourself (unless it's a simple single-table CRUD operation that NPoco generates itself).
3. Latest versions come with Linq expressions support. Back when our project got started there was no Linq support in NPoco and I ended up writing my own Linq-like repository wrapper. (I've made several other customizations to NPoco not all of which have made it into the official codebase, so I can't upgrade.)
The bad:
1. No support for the JOIN syntax in NPoco's Linq implementation. Depending on how you look at it, this can be either a deficiency or a blessing (given how ugly SQL can get with auto-generated joins in EF and other full-feature ORMs).
2. The API can be a little confusing with too many overloaded methods and methods with different names but similar functionality.
|
|
|
|
|
I used it for a project. I didn't use any of the object-relational mapping, but I liked that I could swap this:
SqlConnection conn = new SqlConnection(connString);
string sql = @"select * from MyTable";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (rdr.HasRows)
{
while (rdr.Read())
{
}
rdr.Close();
}
with this:
SqlConnection conn = new SqlConnection(connString);
string sql = @"select * from MyTable";
IEnumerable<object> flatResult = conn.Query<dynamic>(sql);
I thought that was pretty handy, especially for quick prototyping where the table and field names were changing a lot and I didn't want to hassle with altering all the field names and just wanted a quick resultset back.
|
|
|
|
|
Inline SQL for anything (C# code files, etc.) is strongly discouraged at our shop, but I see your point. 
|
|
|
|
|
If you get a bad tattoo, just what were you inking?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
After a long night of drinking I ended up getting a full body tattoo - it was an exact replica of me, only taller.
|
|
|
|
|
Sounds like a tall order for any tattoo artist.
If I were to get a replica of myself, I would have gone for longer... 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
Quote: If you get a bad tattoo, just what were you inking?
FTFY! 
Get me coffee and no one gets hurt!
|
|
|
|
|
If you get an ache in your back, just what were you moving?
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
|
Now, now! The last thing someone with a bad tattoo wants is more needling!
I am not a number. I am a ... no, wait!
|
|
|
|
|
Indeed, that could leave a bad impression.
/ravi
|
|
|
|
|
I could see how one could draw that conclusion.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
|
Tatoo parlors have always been seen as sketchy.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
I agree. They always seem to have designs on me.
/ravi
|
|
|
|
|
Fortunately you've left no trace, they'll never find you.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Methinks they only have to scratch the surface to find me.
/ravi
|
|
|
|
|
Just brush them off if they do.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
|
Nice!  The universe is at it again!
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
|
Hello,
I am new to deal with Wi-fi. I want to send periodically probe request from an access point and then read all the probe response to detect all the devices in the building and can filter and build my application based on these data.
I have the permission to access all the access points and it possible also to add a hardware like wireless controller.
I was looking for a solution I found that it is possible to detect the wifi clients with an access point with a custom firmware update (e.g. Ubiquity PicoStation 2 ) and then they were able to send probe request and receive a probe response.
My question, Is it possible to do the same with already existing access points in the building
My application is academic usage.
I look forward to helping me.
|
|
|
|
|
mohammed qaid wrote: I look forward to helping me.
We look forward to you helping you too! 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
