how to insert only unique records in database using LINQ

Hii
if u want to to check user exist or not just check it through stored procedure and call the proc from your application .i just write the stored proc u just call from app if u dont get plz repl me my mail id [email protected]
 
CREATE PROCEDURE sp_EMPLOYEEINFORMATION
@EMPLOYEEID varchar(50),
@EMPLOYEENAME varchar(50),
@ERROR VARCHAR(100) OUT

AS

BEGIN
              
SET NOCOUNT ON;

---Checking Condition if User exists or not if user not exists returns different message if exists returns different message

IF NOT EXISTS(SELECT * FROM TABLENAME WHERE EMPLOYEENAME =@EMPLOYEENAME )
BEGIN
INSERT INTO TABLENAME
(
EMPLOYEEID,
EMPLOYEENAME
)
VALUES
(
@EMPLOYEEID ,
@EMPLOYEENAME

)
--If User Successfully Registerd I am returing this Message as Output Parameter
SET @ERROR=@EMPLOYEENAME +' Registered Successfully'
END
ELSE
BEGIN
--If User already Exists i am returning this Message as Output Parameter
SET @ERROR=@EMPLOYEENAME + ' Already Exists'
END
END