Timed Database auto maintenance

[King Coffee]

Hi,

I have an ASP.NET database supported website. I want to perform an
automatically generate database update.

Any and all code snippet or reference is greatly appreciated.

Thanks very much,
King Coffee

 

[Alexey Smirnov]

Hi,

I have an ASP.NET database supported website. I want to perform an
automatically generate database update.

Any and all code snippet or reference is greatly appreciated.

Thanks very much,
King Coffee

Can you please be more specific about your database and what you mean
by "update"? Thanks

 

[King Coffee]

Thanks Alexey,

I'm thinking of the MySQL .NET database. The period update is to insert new
default info in tables and delete expired table records.

King

 

[King Coffee]

Hi again,

Basically, I want to run an application level function (a session less
thread) to process an ADO.NET database calls to periodically insert a
default table record and remove expired data. Have any code examples?

King

 

[Alexey Smirnov]

Hi again,

Basically, I want to run an application level function (a session less
thread) to process an ADO.NET database calls to periodically insert a
default table record and remove expired data.  Have any code examples?

King

Well, it would depend on your server, but you can either use standard
Windows scheduler or write a Windows service to call an application or
a single web page every X minutes. If this is not possible, then you
can look at custom solutions like here: http://www.codeproject.com/KB/aspnet/ASPNETService.aspx