Store Procedure
USE [Girfa_ProductDB]
GO
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
ALTER proc [dbo].[fetchProduct]
AS
BEGIN
select id,productname from dbo.product order by productname
END
CHTML
@model IEnumerable<Britanic_MIS.Models.ProductModel>
Product :
<select class="form-control