How to Get all Stored Procedure from C#

Category: .NET
06 Sep 2015 01:33
Joined: 29/05/2009
Level: Gold
Points: 10183
Points: 2
How to Get all Stored Procedure from C#
Hi

I have Mysql Data Base with 50 Stored Procedure .

1.How to Get all Stored Procedure without data using C# code only. No need design side only c# code .

2.How to get Last 5 days created Stored procedure stored to one text file

I need this Mysql Only without Data.
#762157
07 Sep 2015 12:21
Joined: 06/04/2012
Level: Gold
Points: 4135
Points: 3
Hello Kumar,

I have never work on this type of situation. Still i can suggest you some links for reference :

http://stackoverflow.com/questions/169330/simple-way-to-programmatically-get-all-stored-procedures

http://stackoverflow.com/questions/1976248/how-do-i-list-all-non-system-stored-procedures

http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated

Hope this will work for you.
Regards,
Nirav Lalan
DNS Gold Member
"Failure is the path of least persistence"
#762165
07 Sep 2015 03:07
Joined: 03/05/2013
Level: Gold
Points: 15334
Points: 3
Hi DotnetDeveloper,

Implement the stuff whatever you want in database side like below.

SELECT obj.Name as SPName, obj.create_date as SPCreationDate FROM sys.objects obj WHERE obj.create_date >= DATEADD(DAY, -5,GETDATE())

and then you can write all the records in to text file after that.

Hope this will helpful to you..
--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/
#762169
07 Sep 2015 03:32
Joined: 29/05/2009
Level: Gold
Points: 10183
Points: 1
Hi

Thanks for reply Nirav and navanee

But My Requirement is Mysql only.

For ex we can easily generated script in sql server I need same operation in my sql but only raised c# code only.
Name : Dotnet Developer-2015
Email Id :kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

Joined:	29/05/2009
Level:	Gold
Points:	10183

Joined:	06/04/2012
Level:	Gold
Points:	4135

Joined:	03/05/2013
Level:	Gold
Points:	15334

Joined:	29/05/2009
Level:	Gold
Points:	10183

How to Get all Stored Procedure from C#

Email subscription