这是我的输出看起来像...... https://i.stack.imgur.com/EUHj1.png
这是我的后端
Beta_DatabaseEntities db = new Beta_DatabaseEntities();
table2 tb = new table2();
int ID;
string Name;
int Salary;
public void Entry()
{
ID = Convert.ToInt16(id.Text);
Name = name.Text;
Salary = Convert.ToInt32(salary.Text);
}
private void insert_Click(object sender, EventArgs e)
{
Entry();
tb.Id = ID;
tb.Name = Name;
tb.Salary = Salary;
db.table1.Add(tb);
db.SaveChanges();
db.Database.ExecuteSqlCommand("GradeEntry "+)
}
我的存储过程:
create procedure GradeEntry
(@ID int, @name nvarchar(50), @salary int)
As
Begin
if(@salary >= 2500)
Begin
insert into Table2 values(@ID, @name, 'A+', @salary)
End
else if(@salary >= 1000)
Begin
insert into Table2 values(@ID, @name, 'A', @salary)
End
else if(@salary >= 500)
Begin
insert into Table2 values(@ID, @name, 'B', @salary)
End
else
Begin
insert into Table2 values(@ID, @name, 'Interni', @salary)
End
End
我正在使用实体框架,但无法弄清楚如何调用在 C# 中工作的存储过程。我正在使用 Visual Studio 2013
我只想使用实体框架从 C# 调用存储过程。