I am using the code shown here, to connect to SQL Server. This is working properly, but for the past 2 days, I am facing an issue where multiple connections (~2000) are getting opened and not getting disposed. Due to…
I just wanted to know what would happen if there are multiple insert and update statements like (insert into sales(),insert into saledetails(), update sale etc.) getting executed and if any exception occurs then will be a rollback of all or…
I have a method where I used Parallel.ForEach to speed up processing, First it is picking small files and processing fast; for the big files, it is very slow and is slower than the for loop. How can I improve…
I need to add 2 columns(LastTaskCreatedDate & LastTaskUpdatedDate) for a table. I have the query for that 2coulums and I just need to call that query into my repo function. My repo function already has a query inside it which…
basically when in another page someone chooses a category it redirects him to this page and adds "?category=(category he choose)" to the url, then it checks in this page what's his category and pulls the ids from db where the…
As in the title, do you know if there is an ADO.Net connector allowing to read a Realm database? For now I m going to try with CData.MongoDB or MongoDB.Driver (nugets packages ) even if I'm almost sure it won't…
I am new to.NET Visual Studio and building an ASP.NET MVC Application. This is my code and I am getting error on the Add Part namespace proj.Controllers { public class EmployeeController : Controller { // GET: Employee emp_RegEntities dbObj =…
I'm a beginner to ASP.Net and was given a project to try and create an ASP.Net Web Form that calls an ASP.Net Web API that grabs data from an SQL Server. I have no experience working with any of these…
I am connected to my SQL Server database and this is my code : public string Get() { string Sql3 = "(SELECT TOP 10 Raspberry_ID, Raspberry_name, Speaker_Name, currently_playing_song, Speaker_Volume, Speaker_Availability, Speaker_Mute, Date_Time, Speaker_Status, ROW_NUMBER() OVER (ORDER BY Date_Time DESC) AS…
I am passing a list of employee IDs to my ado.net query. Sometimes my list is empty so I am getting error on this condition. The error saying: Incorrect syntax near ')'. Here is my code: var emps = String.Join(",",…