Dot net/EF core auto update migrations in database March 07, 2019 Dot net core Entity framework migrations auto update into database. We can update migrations in database automatically, or we can upda...Read More
Fastest way to get rows count from large table (sql server database) February 01, 2019 Query: SELECT Total_Rows= SUM(ss.row_count) FROM sys.dm_db_partition_stats ss WHERE object_name(object_id) = ' Table name...Read More
Entity Core 2.0 Model With all data annotations (Primary Key, Foreign Key,Identity,Table Name And Schema June 28, 2018 Here is the example for EF core 2.0 model with all data annotations. Primarykey Table: [Table( "Master" , Schema = "Ad...Read More
Log file creating using Log4net in Asp.net and C# November 26, 2015 Log file creating using Log4net in Asp.net and C# By adding log4net.dll reference to project we can create log file. I will show you ste...Read More
Inserting multiple values to database using single textbox with values separated with comma [,] October 19, 2015 Inserting multiple values to database using single textbox with values separated with comma [,]: Front end Code: Am just creat...Read More