Yes We are using SQL Server. No errors its showing uncommitted records also. So, isolation level mentioned as ReadCommitted is not working
Hi,
We tried to enable IsolationLevel.ReadCommitted in app service and found its working for the getall but not for Repository.GetAsync(id) Working for below code: [UnitOfWork(IsolationLevel.ReadCommitted)] public async Task<PagedResultDto<GetCatetoryForViewDto>> GetAll(GetAllCatetoriesInput input) {
var filteredCatetories = _catetoryRepository.GetAll()
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter), e => false || e.Name.Contains(input.Filter) || e.code.Contains(input.Filter))
.WhereIf(!string.IsNullOrWhiteSpace(input.NameFilter), e => e.Name.Contains(input.NameFilter))
.WhereIf(!string.IsNullOrWhiteSpace(input.codeFilter), e => e.code.Contains(input.codeFilter));
var pagedAndFilteredCatetories = filteredCatetories
.OrderBy(input.Sorting ?? "id asc")
.PageBy(input);
var catetories = from o in pagedAndFilteredCatetories
select new
{
o.Name,
o.code,
Id = o.Id
};
var totalCount = await filteredCatetories.CountAsync();
var dbList = await catetories.ToListAsync();
var results = new List<GetCatetoryForViewDto>();
foreach (var o in dbList)
{
var res = new GetCatetoryForViewDto()
{
Catetory = new CatetoryDto
{
Name = o.Name,
code = o.code,
Id = o.Id,
}
};
results.Add(res);
}
return new PagedResultDto<GetCatetoryForViewDto>(
totalCount,
results
);
}
Not Working for this one [UnitOfWork(IsolationLevel.ReadCommitted)] public async Task<GetCatetoryForViewDto> GetCatetoryForView(int id) { var catetory = await _catetoryRepository.GetAsync(id);
var output = new GetCatetoryForViewDto { Catetory = ObjectMapper.Map<CatetoryDto>(catetory) };
return output;
}
Please suggest way how we can implement the same.
Regards, Harshit
Hi,
I need HTML format message in user friendly exception. I tried on app_layout_lib.min.js file with isHTML: true and this is working fine, But after minify, code is automatically removed to default code. Please suggest me.
Hi, I am creating users directly from database using store procedure. All work is done but i am not able to set password in encrypted with my dynamic string. can use help us what algorithm is use in ASP.Net Zero for user password.
Thanks, Mohit
Hi,
Could you share the CSV file ?
Shared on mail . Please check the same.
What is your product version? 8.1 What is your product type (Angular or MVC)? MVC What is product framework type (.net framework or .net core)? .net core
CSV format is not working while uploading csv file please check screenshot. Its giving error "wrong local header signature: 0x69616d45"
Yes. its localhost as we are trying to test in debug mode using Visual studio. and the same error come on production URL
I saw the link but need you help how we can use it.
Thanks Harshit