如何在C＃中创建存储过程，然后将其“保存”到SQL Server？

如何在C＃中创建存储过程，然后将其“保存”到SQL Server？

是的，这是可能的。在这里，我给你一个例子。

public partial class InitialEntities : DbMigration  {  public override void Up()  {      CreateStoredProcedure(          "dbo.InsertEmployee",p => new          {   Code = p.String(),   Name = p.String(),   DepartmentId = p.Int(),          },          body:   @"INSERT [dbo].[EmployeeMasters]([Code], [Name], [DepartmentId])          VALUES (@Code, @Name, @DepartmentId)        DECLARE @EmployeeId int          SELECt @EmployeeId = [EmployeeId]          FROM [dbo].[EmployeeMasters]          WHERe @@ROWCOUNT > 0 AND [EmployeeId] = scope_identity()        SELECt t0.[EmployeeId]          FROM [dbo].[EmployeeMasters] AS t0          WHERe @@ROWCOUNT > 0 AND t0.[EmployeeId] = @EmployeeId"      );    CreateStoredProcedure(          "dbo.UpdateEmployee",          p => new          {   EmployeeId = p.Int(),   Code = p.String(),   Name = p.String(),   DepartmentId = p.Int(),          },          body:   @"UPDATE [dbo].[EmployeeMasters]          SET [Code] = @Code, [Name] = @Name, [DepartmentId] = @DepartmentId          WHERe ([EmployeeId] = @EmployeeId)"      );    CreateStoredProcedure(          "dbo.DeleteEmployee",          p => new          {   EmployeeId = p.Int(),          },          body:   @"DELETE [dbo].[EmployeeMasters]          WHERe ([EmployeeId] = @EmployeeId)"      );}public override void Down()  {      DropStoredProcedure("dbo.DeleteEmployee");      DropStoredProcedure("dbo.UpdateEmployee");      DropStoredProcedure("dbo.InsertEmployee");  }  }

没有实体框架

 StringBuilder sbSP = new StringBuilder(); sbSP.AppendLine("CREATE PROCEDURE [spInsertADAuthorization] @AD_Account varchar(255),@AD_SID varchar(255),@AD_EmailAddress varchar(255),@Dateimported datetime,@Active bit AS BEGIN SET NOCOUNT ON; INSERT INTO AD_Authorization (AD_Account, AD_SID, AD_EmailAddress, Dateimported, Active) VALUES (@AD_Account,@AD_SID,@AD_EmailAddress,@Dateimported,@Active) END");using (SqlConnection connection = new SqlConnection(ConnectionString)){ using (SqlCommand cmd = new SqlCommand(sbSP.ToString(), connection))  {      connection.Open();      cmd.CommandType = CommandType.Text;      cmd.ExecuteNonQuery();      connection.Close();  }         }