A Programmer with Microsoft tools

  • EF,automatic history of table and T4 files (TT files)

    Usually the data of the tables should be tracking for who modified it. Think about inserting/updating/deleting an employee :   you must know who did those actions and when. So you create another table,identically as structure,and you add another 3 fields,such as [ModifiedDate](when),[ModifiedBy](who),[ModifiedType] (what : insert,update,delete). There are several methods to do it : from database…

  • For all programmers

    For all programmer,just remember : http://timstall.dotnetdevelopersjournal.com/coding_is_just_the_tip_of_the_iceberg.htm And he says nothing about clients,marketing,sales,promotion,SEO,SMM,and other usual stuff…

  • Monitor SqlServer Stored Proc execution time

    I have had the task to made something to monitor what stored procedure,in Sql Server,in most used. The problem that I have had is that the host_name is easily changed by putting,in the connection string WSID (see http://msdn.microsoft.com/en-us/library/ms178598.aspx ) The code is for sql server 2005 and I have not realized without the help of…

  • file helpers

    More than one time you need to let users / application import bulk data in your system . I have had many cases  – data is old data from old software,that is exported in some text files,usually csv. In order to import fast the data,I used FileHelpers from http://www.filehelpers.com/ Let’s say you have the following…

  • Twitter Weekly Updates for 2010-06-06

    .net salary http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=21216925&gid=136510&commentID=17252387&trk=view_disc # Powered by Twitter Tools

  • MVC Helper Templates

    In my experiences with MVC I have some utilities to share . Some of them are : DateTime fields Numeric fields Watermark Dropdownlist more! Please see the project and give feedback MvcHelperApplication

  • Selenium and testing WebInterfaces

    On some cases you need to test the whole web interface. Why ? Suppose you have some Ajax call. You can test the call on server,but how do you ensure that user experience is OK ? There are several testing projects for Web – for example selenium and Watin I will show how to test…

  • Entity Framework profiler

    Many times I’ve had problem with the following error when inserting objects with dates with Entity Framework : System.Data.UpdateException An error occurred while updating the entries. See the inner exception for details.SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Ok,it’s my faute – but to remember each one date is too…

  • Twitter Weekly Updates for 2010-05-09

    The State of Web Development 2010 http://www.webdirections.org/sotw10/ # Powered by Twitter Tools

  • Caching in .NET

    In every application you have some data that is more read-more,write-once or twice. For example you can have the list of Cities of a country,the list of Countries of the world or list of exchange currency. This data is modified rarely. Also,you can have data that is not very sensitive to be real-time,such as the…

I am ok , you are ok

Do nothing