Categories
c# entity-framework sql

Translating Insert into Select to Entity Framework

I have this sql query that i want to translate to entity Framework

i need to insert more than one row in one run in entity like what this query do

INSERT INTO dbo.tbllistDepartment
(
department_sys_id,
department,
status,
client_sys_id,
lang_sys_id
)
SELECT @siDepartmentSysId,@siDepartment, @iiStatus,
@siClientSysId, lang_sys_id
FROM tblLanguageSettings
WHERE lang_sys_id <> 'Admin001'

i have tried this but its inserting just one row

public static void Insert(string langSysId, string clientSysId,string name, int status)
{
Crs2Model context = new Crs2Model();
string SysId = MyLibrary.StringCreator.GetSysId();
tblListDepartment deptObj = new tblListDepartment()
{
department_sys_id = SysId,
client_sys_id = clientSysId,
lang_sys_id=langSysId,
department=name,
status=status
};
context.tblListDepartments.Add(deptObj);
context.SaveChanges();
}