Thursday, August 19, 2021

 How to generate Model class and DbContext from existing Data Base using .NET Core 

Open the Nuget Manage and run the following command
Scaffold-DbContext Name=DBConnection Microsoft.EntityFrameworkCore.SqlServer -OutputDir Model -Tables KpiSMSLog

Which will only include the table name kpismslog

To specify Name Space

PM> Scaffold-DbContext Name=HostDB Microsoft.EntityFrameworkCore.SqlServer -Namespace ScheduleMonitor -ContextNamespace ScheduleMonitor.Business


Script migration Changes

Script-Migration -From 20200810134651_partyIdentifer_column -To 20201118122724_SAPuserIdColumn 

How to reset the Identity column value using SQL

DBCC CHECKIDENT('Bookings', RESEED, 1)


Thursday, January 31, 2013

multi file upload using MVC


http://lbrtdotnet.wordpress.com/2011/09/02/asp-net-mvc-multiple-file-uploads-using-uploadify-and-jqueryui-progressbar/

Monday, September 10, 2012

Tuesday, June 14, 2011

Run as administrator on Shortcuts using Visual studio setup project

Use Microsoft's ORCA tool
  • This is provided as p art of the "Windows Installer SDK" which is part of the "Win dows Platform SDK"
  • After installing the Platform SDK you actually have to install ORCA. Its setup file will be in the directory where the Platform SDK was installed.
  • Run ORCA and open the MSI file
  • Select the table "Property"
  • Add a row to the "Property" table with the following values for the columns
    • Property: DISABLEADVTSHORTCUTS
    • Value: 1

 How to generate Model class and DbContext from existing Data Base using .NET Core  Open the Nuget Manage and run the following command Scaf...