My article on ASP .Net Web API in Code Project website has attracted nearly 4000 views and 22 Bookmarks. Please find the article blog here
ASP.NET Web API is a framework for building HTTP services that can be accessed from various clients, such as browsers and mobile devices. ASP.NET Web API was introduced as part of ASP.NET MVC 4
We had a requirement to update the TFS database. Scenario is that we have one custom field in the Task work item, which is defined as string. For getting a proper report, we need to change the data type of the custom field to double. Team deployed the SQL script, which will change the custom field type from string to double. Moreover, the script mark the field as reportable. This change in turn affected the TFS warehouse and analysis databases and the report generation stopped.
Whenever there is a TFS database change, which mark the field as reportable, follow the steps to properly deploy the same into production.
1. Prepare the SQL Script to do the TFS database change
2. Regenerate both warehouse and analysis databases using TFS Admin Console
3. Queue the warehouse and analysis process
Regeneration of TFS warehouse and analysis databases ensure the proper schema update from the modified TFS database.
Recently we came across one of the scheduling issue reported by a client. He is having an executable (exe) which process an excel file, create tables in database, populate values to the database and generate log files (csv). When we scheduled the exe execution using Windows Scheduler it works fine. But, when we marked the task to execute when the user is not logged into the system, the task fails to process the excel files.
After lot of analysis we have fixed the issue with a simple solution. Create one folder called “Desktop” under the following paths
Note:- Depends on 32-bit or 64-bit, we can create the folder under the respective folder.
When the user is not logged into the system, system uses the specified path as temporary location to process the excel (may be office) files.
When we try to generate a database instance using Entity framework and Factory methods, we have received the error “Resolution of the dependency failed“.
Include the following libraries in the class, where we create the database instance
then use following line to get the database instance
var db = EnterpriseLibraryContainer.Current.GetInstance<Database>();
Posted in C#
Tagged Entity Framework
Background process is used in different applications to perform various activities in the background, which doesn’t require any kind of user interaction. Mainly CPU centric long running processes are designed using the background process. Background processes have a significant role in Windows 8 Store app development compared to other areas. The requirement for background process arises due to the new process life cycle introduced in Store apps.
Refer my article on Windows 8 – background processing to understand the importance of background process in Windows 8 store app development.