Posts

Showing posts from August, 2011

C# Log4Net configuration for multiple processes with date rolling

madeinstein ,
This example uses MinimalLock locking Model to allow multiple processes to write to the same file <appender name=" RollingFileAppender " type=" log4net.Appender.RollingFileAppender "> <file value =" Log\\MyApp.log "/> <appendToFile value =" true "/> <rollingStyle value =" Date "/> <datePattern value =" .yyyyMMdd "/> <maxSizeRollBackups value =" 7 "/> <staticLogFileName value =" true "/> <threshold value =" INFO "/> <lockingModel type=" log4net.Appender.FileAppender+MinimalLock " /> <layout type=" log4net.Layout.PatternLayout "> <conversionPattern value =" %d [%t] %-5p %c.%M():%L - %m%n "/> </layout> </appender> Click here for more detailed post about Log4Net configuration in console apps
Post a Comment
Read more

C# Send email with embedded image

madeinstein ,
string mailserver = " mymailserver "; string subject = " Email with picture "; string body = " <html><body><h1>Picture</h1><br><img src=\"cid:Pic1\"></body></html> "; string to = " to@email.com "; string from = " from@email.com "; string imagePath = @" c:\temp\myimage.png "; AlternateView view = AlternateView.CreateAlternateViewFromString(body, null , MediaTypeNames.Text.Html); LinkedResource pic = new LinkedResource(imagePath, MediaTypeNames.Image.Gif); pic.ContentId = " Pic "; view.LinkedResources.Add(pic); MailMessage m = new MailMessage(); m.AlternateViews.Add(view); m.From = new MailAddress(from); m.To.Add( new MailAddress(to)); m.Subject = subject; SmtpClient client = new SmtpClient(mailserver); client.Send(m);
Post a Comment
Read more

SQL Delete in batches based on date

madeinstein ,
This is a sample how to delete data in batches to avoid large transaction log. This is a simpler version of this example when I used 2 tables. DECLARE @MyTable TABLE ( Id int , DateUpdated DATETIME ) INSERT INTO @MyTable SELECT 1,DATEADD(d,-1,GETDATE()) UNION SELECT 2,DATEADD(d,-2,GETDATE()) UNION SELECT 3,DATEADD(d,1,GETDATE()) UNION SELECT 4,DATEADD(d,2,GETDATE()) UNION SELECT 5,DATEADD(d,-3,GETDATE()) UNION SELECT 6,DATEADD(d,-2,GETDATE()) UNION SELECT 7,DATEADD(d,-4,GETDATE()) DECLARE @ date DATETIME SET @ date = GETDATE() PRINT CONVERT ( CHAR (19),GETDATE(),120) +' Deleting data in batches ' WHILE ( Exists ( SELECT 1 FROM @MyTable WHERE DateUpdated < @ date )) BEGIN TRY BEGIN TRAN PRINT CONVERT ( CHAR (19),GETDATE(),120) +' Deleting 2.. ' DELETE TOP (2) @MyTable FROM @MyTable WHERE DateUpdated < @ date COMMIT TRAN END TRY BEGIN CATCH ROLLBACK END CATCH --SELECT * FRO
Post a Comment
Read more

Retry class implemented in functional C#

madeinstein ,
public class Retry { public static ILog _log = LogManager.GetLogger(MethodInfo.GetCurrentMethod().DeclaringType); int _retryAttempts = 3; int _retryWaitSeconds = 1; public Retry() { } public Retry( int retryAttempts, int retryWaitSeconds) { _retryAttempts = retryAttempts; _retryWaitSeconds = retryWaitSeconds; } public void Execute(Action action) { int attempt = 0; while (attempt++ < _retryAttempts) { try { if (_log.IsDebugEnabled) { _log.DebugFormat(" Retry attempt {0}/{1} ", attempt, _retryAttempts); } action(); return ; } catch (Exception e) { if (attempt >= _retryAttempts) { _log.ErrorFormat(" Retry failed with {0} attempts ", _retryAttempts); throw e; } int wait = _retryWaitSeconds * attempt; _log.Warn( string .Format(" Retry attempt {0}/{1} failed, waiting
Post a Comment
Read more

Visual Studio Web Server not updating/caching pages

madeinstein ,
Image
I came across a problem today when visual studio development web server was not updating when compiling new code. After deleting bin folder from my Web project I got this error: The problem was with build output location. For web projects the Output path in web project properties should be just bin not bin\Debug or bin\x86\Debug because web server root folder is your Web project folder.
Post a Comment
Read more

C# MVC3 Log4Net configuration

madeinstein ,
Add log4net section to top level Web.config <configuration> <configSections> <section name=" log4net " type=" log4net.Config.Log4NetConfigurationSectionHandler,log4net " /> </configSections> [...] <log4net> <appender name=" RollingFileAppender " type=" log4net.Appender.RollingFileAppender "> <param name=" File " value =" Log\\MyProject.log " /> <param name=" AppendToFile " value =" true " /> <param name=" RollingStyle " value =" Size " /> <param name=" MaxSizeRollBackups " value =" 10 " /> <param name=" MaximumFileSize " value =" 500KB " /> <param name=" StaticLogFileName " value =" true " /> <param name=" Threshold " value =" INFO "/> <layout type=" log4net.
Post a Comment
Read more