Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hi,
I need run simple sql command (shrink transaction log) .In v3 I use sqlCommand, in v4 there datalayer is introduced, but I can't find any documentation how to use it. What is recommended way to do it in v4?
Thanks
Hi Petr,
You could try something like:
SqlHelper.ExecuteNonQuery("truncate table cmsContentXml");
HTH,
PeterD
does the SqlHelper allow you to retrieve or select all data from the database
@Max, yup it certainly does. Assuming you want a DataReader, you can use SqlHelper.ExecuteReader() to return info from the database.
:)
You can find an example of the SqlHelper here in the UpdateDAMP method: http://damp.codeplex.com/SourceControl/changeset/view/86116#1765747
Jeroen
Oh, sqlhelper is discussed here? I just completed a performance study on it. please refer to Proformance study in sqlhelper
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Using datalayer
Hi,
I need run simple sql command (shrink transaction log) .In v3 I use sqlCommand, in v4 there datalayer is introduced, but I can't find any documentation how to use it. What is recommended way to do it in v4?
Thanks
Hi Petr,
You could try something like:
HTH,
PeterD
does the SqlHelper allow you to retrieve or select all data from the database
@Max, yup it certainly does. Assuming you want a DataReader, you can use SqlHelper.ExecuteReader() to return info from the database.
:)
You can find an example of the SqlHelper here in the UpdateDAMP method: http://damp.codeplex.com/SourceControl/changeset/view/86116#1765747
Jeroen
Oh, sqlhelper is discussed here? I just completed a performance study on it. please refer to Proformance study in sqlhelper
is working on a reply...