bhola kumar

bhola kumar

  • NA
  • 2
  • 1.4k

Read and alter Sql Server object in c#

May 21 2015 7:32 AM
I have written one sample Sql stored procedure.
USE [Db]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_TestProcedure]
AS
BEGIN
SET NOCOUNT ON;
PRINT 'Good evening'
END
Its working fine. Now I want to read and alter this stored procedure (and db object like function and view) using c#. Can it be done using c# ?
I am using Server 2014 and C#4.5.

Answers (1)