I made a database for my project for ASP.NET in Visual Studio. Then I made a table however after updating the table, Visual Studio itself named it as 'Table'. Now when I'm trying to run a query: select * from…
all of a sudden my laravel app has stopped connecting to SQL server database. No matter what i do, i get the error SQLSTATE[IMSSP]: An invalid attribute was designated on the PDO object. I am able to connect to the…
We use SQLBase for our development in various versions, including 12.2. Our main application is a Team Developer application (Version 7.5) that utilizes SQLBase as its database. In addition to Team Developer, we program in C# (.NET Core). We're quite…
I have JSON like this: { "_key": { "id": "3b8d1ed7-c3ec-32ec-a083-2ddc17152e94", "rootId": "15c85327-9628-3685-b84a-375b546ba92a" }, "employeeInfo": { "idNumber": "3", "gender": "Male", "active": true, "age": 20 }, "product": { "plan": "prod", "class": "1", "available": true, "_type": "Product" } } And I want to…
I'm looking for a reliable strategy that will allow me to relate a performance problem that the Azure portal has highlighted, back to some query in the C# .NET 7 / EF Core 7 app that has generated that query.…
I'm trying to fetch a record from MSSQL table based on field value which contains json data. Following is the sample column value for 'updated_value' column: [[{"phone_number":"5555555555","phone_type":"H","inactive_date":null,"restrictions":["SU","F"],"start_time":null,"end_time":null}]] My query is: $existing = ContactChangeLogs::latest() ->where('updated_value->phone_number', '5555555555') ->first(); But dd($existing) gives null…
I want to access db mongo/SQL Server in the most effective way. From my perspective, I will just use context as singleton and that's all. I worked before at a company where they use all the logic services as singleton…
so I ran my SSIS Job on my local machine with no errors and deployed it to SQL Agent 2019 and I'm using Visual Studio 2019 and the TargetVersion is set to SQL Server 2019 and I'm getting the followings…
I have the following connection string in my web.config: <add name="ConvMapping.Properties.Settings.ifl" connectionString="Data Source=serverInfo;Initial Catalog=database;Persist Security Info=True;User ID=userid;Password=password" providerName="System.Data.SqlClient" />` The issue is now we have to use the database based on a selection. So, example I want to do something…
I wrote the SQL Server stored procedure usp_getrowcounts, shown below, that dynamically gets a row count from each table, as tables come and go, and need the equivalent dynamically generated and executed PL/SQL to work in PostgreSQL. However, working with…