Stored procedure with EF core

ByAnurag batra July 1, 2022June 30, 2022

var emailAddressParam = new SqlParameter("@emailAddress", id.EmailAddress);
var passwordParam = new SqlParameter("@passwordHash", id.PasswordHash);

var users = context
            .UserProfiles
            .FromSqlRaw("exec sp_GetUsers @emailAddress, @passwordHash", emailAddressParam, passwordParam)
            .ToList();

Here is what the above code is Doing:
1. Create a new instance of the SqlParameter class for each parameter in the stored procedure.
2. Use the FromSqlRaw method to execute the stored procedure.
3. Pass the SqlParameter instances to the stored procedure.
4. Use the ToList method to return the results as a list of UserProfile objects.

Javascript Examples

js random minus

ByAnurag batra July 22, 2022June 30, 2022

var plusOrMinus = Math.random() < 0.5 ? -1 : 1; Here is what the above code is Doing: 1. We're creating a variable called plusOrMinus and setting it equal to a random number between 0 and 1. 2. We're using an if/else statement to check if the random number is less than 0.5. 3. If...

Javascript Examples

how to empty an element in javascript

ByAnurag batra July 30, 2022June 30, 2022

//using javascript document.getElementById(elementID).innerHTML = “”; //using JQuery $(‘#elementID’).html(”); Here is what the above code is Doing: 1. We are selecting the element with the id of elementID. 2. We are setting the innerHTML of that element to an empty string.

how to pass the data from one page to another in javascript

Javascript Examples

how to pass the data from one page to another in javascript

ByAnurag batra July 6, 2022June 30, 2022

var favoritemovie = “Shrek”; sessionStorage.setItem(“favoriteMovie”, favoritemovie); Here is what the above code is Doing: 1. We create a variable called favoritemovie and set it equal to the string “Shrek”. 2. We then use the setItem() method to create a key called “favoriteMovie” and set its value to the string “Shrek”.

check if field exists in object javascript

Javascript Examples

check if field exists in object javascript

ByAnurag batra July 7, 2022June 30, 2022

const hero = { name: ‘Batman’ }; hero.hasOwnProperty(‘name’); // => true hero.hasOwnProperty(‘realName’); // => false Here is what the above code is Doing: 1. We create an object called hero. 2. We check if the hero object has a property called name. 3. We check if the hero object has a property called realName. The…

Javascript Examples

jquery escape html string

ByAnurag batra July 23, 2022June 30, 2022

function escapeHtml(str) { return str.replace(/&/g, “&”).replace(//g, “>”).replace(/”/g, “"”).replace(/’/g, “'”); } Here is what the above code is Doing: 1. We’re creating a function called escapeHtml() that takes in a string as an argument. 2. We’re using the replace() method to replace the characters &, , “, and ‘ with their HTML entity equivalents. 3. We’re…

Javascript Examples

mongoose response to object

ByAnurag batra July 26, 2022June 30, 2022

MyModel.findOne().lean().exec(function(err, doc) { doc.addedProperty = ‘foobar’; res.json(doc); }); Here is what the above code is Doing: 1. Find a document in the database 2. Convert the document to a plain JavaScript object 3. Add a new property to the object 4. Send the object back to the client The problem with this approach is that…

Similar Posts