Fastest way to get rows count from large table (sql server database)
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
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#
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 [,]
Inserting multiple values to database using single textbox with values separated with comma [,]: Front end Code: Am just creat...Read More
Dataset Brief Explanation - C#.net, asp.net
Dataset: dataset is a collection of data tables. We can store many data tables into single dataset. Dataset acts like set of data tabl...Read More
Subscribe to:
Posts
(
Atom
)