How to call SQL Function in C#
By FoxLearn 11/10/2024 11:44:24 AM 91
To call an SQL function in C#, you'll typically interact with your database using ADO.NET, Entity Framework, or an ORM like Dapper.
Consider you have an SQL function in SQL Server called GetEmployeeSalary
that takes an EmployeeID
and returns the salary:
CREATE FUNCTION GetEmployeeSalary (@EmployeeID INT) RETURNS DECIMAL AS BEGIN DECLARE @Salary DECIMAL SELECT @Salary = Salary FROM Employees WHERE EmployeeID = @EmployeeID RETURN @Salary END
You can call a SQL function by using ADO.NET.
For example:
public decimal CallSqlFunc(int EmployeeId) { decimal salary = 0; using (var con = new SqlConnection(ConfigurationManager.AppSettings["connectionString"])) { con.Open(); var cmd = new SqlCommand("SELECT dbo.GetEmployeeSalary(@EmployeeId)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@
EmployeeId",
EmployeeId); object result = cmd.ExecuteScalar(); if (result != DBNull.Value) { salary = Convert.ToDecimal(result); } return salary; } }
SqlConnection
: This establishes a connection to your database using a connection string
SqlCommand
: This is used to execute SQL queries.
ExecuteScalar()
is used to execute the SQL function and retrieve a single value.
SqlParameter
: This ensures safe parameterized queries, avoiding SQL injection.
This method demonstrates how to call an SQL function from C# using ADO.NET.
- How to Call the Base Constructor in C#
- Deep Copy of Object in C#
- How to Catch Multiple Exceptions in C#
- How to cast int to enum in C#
- What is the difference between String and string in C#?
- How to retrieve the Downloads Directory Path in C#
- How to implement keyboard shortcuts in a Windows Forms application
- How to get current assembly in C#
Categories
Popular Posts
Material Lite Admin Template
11/14/2024
Freedash bootstrap lite
11/13/2024
RuangAdmin Template
11/17/2024
Responsive Animated Login Form
11/11/2024