// @nuget: EntityFramework

​

using System;

using System.Data.Entity;

using System.Linq;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations.Schema;

using System.ComponentModel.DataAnnotations;

​

public class Program

{

    public static void Main()

    {

        CreateStoredProcedure();

        using (var context = new BookStore())

        {           

            int affectedRows = context.Database.ExecuteSqlCommand("CreateAuthor @p0, @p1, @p2",

                parameters: new[] 

                {

                    "Mark",

                    "Cuban",

                    "23 Tsawassen Blvd."

                });

            FiddleHelper.WriteTable(context.Authors);

        }

    }

    public static void CreateStoredProcedure()

    {

        using (var context = new BookStore())

        {

            var noOfRows = context.Database

                        .ExecuteSqlCommand(

@"IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

   OBJECT_ID(N'[dbo].[CreateAuthor]') AND type in (N'P', N'PC'))

​

BEGIN

    EXEC dbo.sp_executesql @statement = N'

    CREATE PROCEDURE [dbo].[CreateAuthor]

        @FirstName Varchar(50),

        @LastName Varchar(50),

        @Address Varchar(100)

    AS

    INSERT INTO dbo.Authors(

        [FirstName],

        [LastName],

        [Address]

    )

    VALUES (@FirstName, @LastName, @Address)

    '

END");

        }

    }

    public class BookStore : DbContext

    {

        public BookStore() : base(FiddleHelper.GetConnectionStringSqlServer())

        {

        }

​

        public DbSet<Author> Authors { get; set; }

    }

​

    public class Author

    {

        public int AuthorId { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public string Address { get; set; }

    }

}