|
are there any examples on how do i call stored procedures with parameters using Dapper.net using query async? Thanks a lot.
|
|
|
|
|
There's an example of calling a stored procedure right on the project home page[^]:
var user = cnn.Query<User>("spGetUser", new { Id = 1 }, commandType: CommandType.StoredProcedure).SingleOrDefault();
Changing that to QueryAsync is fairly simple:
IEnumerable<User> users = await cnn.QueryAsync<User>("spGetUser", new { Id = 1 }, commandType: CommandType.StoredProcedure);
User user = users.SingleOrDefault();
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Saw this in an example when setting properties.
Is this some kind of special ASP.NET MVC syntax?
var movie = new Movie() {
Name = "Shrek!"
};
Where Name is a property of the class Movie.
|
|
|
|
|
No, there's no such thing as a "special syntax for ASP.NET MVC".
That's standard C# syntax that's been around since VS2008.
|
|
|
|
|
Read this. Seriously, do it.
"If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome"
"Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid"
modified 28-Jun-16 9:06am.
|
|
|
|
|
Read Dave's response again. He didn't insult you; he just answered your question - and correctly at that.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Ummm... what's wrong with you?
How on this planet did I insult you?
|
|
|
|
|
I think adding the "Seriously, do it" was unnecessary, like I was some idiot.
You could have only said "please read this" or something.
|
|
|
|
|
larsp777 wrote: I think adding the "Seriously, do it" was unnecessary, like I was some idiot.
Lighten up, Francis. I hate to tell you this, but that's part of my signature. It shows up on everything I post here.
Why do I have that link in there? Because over the 13 years I've been around here I've watched the quality of questions plummet. There are so many "questions" asked around here that don't qualify as questions at all and usually don't have any context to frame the question nor enough detail to answer them.
Asking questions really is a skill. As you are/were a teacher:
Hi! I am a teaches a course in C# for beginners.
you should already know this.
|
|
|
|
|
Well, as said, I realized that it was in your signature and again, I apologize humbly.
Yes, I been a teacher for C# beginners but have alot to learn myself obviously
|
|
|
|
|
Oh, really sorry!
Realize now that it was in your signature.
again, I apologize.
|
|
|
|
|
|
|
As I said I misunderstood.
It was the signature, not aimed at me.
Yes, he did answer my question and thanks for the further clarification.
|
|
|
|
|
I suggest you revoke your down-vote on Dave's message by clicking the green arrow next to it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Hm, so when do you use this? Feels like everything I thought my students about private variables and getters and setters is obsolete...
Here´s something to put in my signature.
The more I learn the more I realize how little I know...
|
|
|
|
|
It doesn't replace the property stuff at all. In fact, this syntax uses those properties. The syntax change is just "shortcut sugar" to avoid having to new up the type and then add a bunch of code to set the properties in multiple statements.
|
|
|
|
|
It's just syntactic sugar designed to reduce the amount of code you type. It doesn't render any of your previous knowledge obsolete, it's just that it's easier to read something like this:
Movie movie = new Movie
{
Name = "Batman vs Superman",
ReleaseYear = 2016,
Rating = 4.5
} Than it is to read this:
Movie movie = new Movie();
movie.Name = "Batman vs Superman";
movie.ReleaseYear = 2016;
movie.Rating = 4.5; It also means you don't have to provide multiple overloaded constructors if you're just providing properties that you want to populate. I don't want to blow your mind, but you can extend this concept to also include collection initialisation as well. Suppose you added a list of actors to your class, you can initialise it like this:
Movie movie = new Movie
{
Name = "Batman vs Superman",
ReleaseYear = 2016,
Rating = 4.5,
Actors = new List<string> { "Ben Afleck", "Jessie Eisenberg", "Gal Gadot", "Henry Cavill" }
};
This space for rent
|
|
|
|
|
No; It's already available in c# language called as object initializer.
for eg :- Student objstd=new Student(){
Name ="Surya",
roll=112,
Adress="Hyd"
};
So it's available in net framework version 3.0 on word.
|
|
|
|
|
How can I copy present address to permanent address using checkbox,when I checked checkbox present address must copy to permanent address in mvc5
|
|
|
|
|
Try posting the code that you are having problems with - it might help us understand your question
|
|
|
|
|
Ummm....WHAT??
"Present address"?? "permanent address"?? How does a checkbox relate to this?
You've failed to provide any context at all and now definitions for these terms. It's pretty much impossible to help you until you do.
|
|
|
|
|
You'll either need JavaScript to hook up the checkbox "checked" event with the copy operation on the client side; or check the value of the checkbox in the controller code on the server and do the copy there.
|
|
|
|