Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Code-First Stored Procedure Entity Framework 6.0

Code-First Stored Procedure Entity Framework 6.0   This blog shows configuration of code first making use of stored procedure for the entities. For usage of stored procedure, the OnModelCreating method of DBContext should be overriden,...

Difference between LINQ and Stored procedure

 LINQ and Stored procedure   LINQ provides a query syntax used for querying different data sources like SQL server, Oracle, Collections etc. Type checking is done at compile time in LINQ. DOT NET framework languages like C# a...

Passing a DataTable Parameter to Stored Procedure from C#

Some time we need to pass a tabular form data to our database. one option is to using loop in Datatable and on every iteration we have to make a Database call. But this approach is not too good and also it's a time taking and decrease our appli...

Stored Procedures and Functions in MySQL- Part 6

Loops A lot many times, situation arises that a set of commands have to be repeatedly executed. This is achievable by using looping constructs. MySQL provides us three types of looping constructs : Simple Loops Repeat Loops While L...

Stored Procedures and Functions in MySQL- Part 1

Why do we need stored routines? In this multi-part series I will explain the need of stored routines commonly know as stored procedures and functions , how to manage them, how to declare variables, programming blocks (loops, how to perform con...

Advantages of using stored procedures :

Stored Procedures stored procedures is the collection of Sql statements which is stored in data base . below are the advantage of stored procedures : 1.stored procedures reducing network traffic and boost application performance. . ...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: