.NET EF Core - A scalar valued function for a demo

GetStudentsWithSameLastName.sql

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[GetStudentsCountWithSameLastName]
(
	@lastName nvarchar(50)
)
RETURNS INT
AS
BEGIN
  	-- Variable
	DECLARE @numberOfStudents int;
	
  	-- Populate number of records variable
	SELECT @numberOfStudents = COUNT(*)
	FROM Students 
	WHERE LastName = @lastName;

	-- Return the number of records
	RETURN @numberOfStudents;

END
GO