Home > Shirish Batule

Difference between build, Rebuild and Clean Solution.

Build solution menu: - This will perform an incremental build. In other words it will only build code files which have changed. If they have not changed those files will not touched.  Rebuild solution menu: - This will delete all current compiled files (i.e. exe and dll's) and will build everything

This Article is TAGGED in , . Read more

Lazy loading in entity framework

One of the biggest issue when we use entity framework that is when we request for one single table you will get all related tables in table object. for example: [crayon-678a1f67bda53161113213/]  in above code you will get all related tables in company object. We can avoid this using Lazy loading. for example: [crayon-678a1f67bda58398902365/]  in this case you can get only

This Article is TAGGED in , , , , , . Read more

How to get notification from database when any transaction on records?

Technologies Used: Visual Studio 2013 Express Sql Server 2008 R2 Express MVC 5 Nuget SqlDependency MSDN SignalR 2.0.1 Nuget Jquery 2.0.3 Nuget Toast Notifications Script to Create Broker & Service: create a user called "GeneralUser" with a password of "dbpassword" in your SQl Server logins. Run the following script in a Sql query pane, to create a message broker\service for

This Article is TAGGED in , , , , , , . Read more

How to import data from MS Excel

If you have data in excel and you want to add data in you database using C# this is useful example. Follow below steps: Step 1: Create database tables to import data [crayon-678a1f67be1b1542097954/] Step 2: Add below namespaces in your project [crayon-678a1f67be1b5260430306/] Step 3:  Add below method and send file path to this method as parameters. [crayon-678a1f67be1b6657894048/]  This method get file path

This Article is TAGGED in , , , , . Read more