Entity Framework using AsNoTracking

Speed up
Using case in no save, update
Only using in list show

Sample


using (var ctx = new REG_RULEEntities())
{
	var rule_number = ctx.RULE_NUMBER.AsNoTracking()
			   .Where(s => s.RULE_NUM == RULE_NUM)
			   .FirstOrDefault();
}

using (var ctx = new REG_RULEEntities())

{

var rule_number = ctx.RULE_NUMBER.AsNoTracking()

.Where(s => s.RULE_NUM == RULE_NUM)

.FirstOrDefault();

}