All Questions
40 questions
1
vote
0
answers
102
views
Problem upgrading .NET 3.1 to .NET 8, context.GetService cannot be used inside OnModelCreating
I am trying to transfer my whole project from .NET 3.1 to .NET 8.
I have resolved some smaller issues but have encountered this major issue which stops me from completing the transition.
What I have ...
- 41
1
vote
1
answer
58
views
Transfer data from Postgre to Microsoft Sql Server
I want to transfer data from Postgre with context _rentContext to Microsoft Sql Server with context _rentContextSql.
In my program first I check if that record exists in _rentContextSql it doesn't add ...
1
vote
0
answers
345
views
How to configure docker compose file to use .net core web api and mssql
I am trying to configure docker-compose file to have possibility to run several services of the whole application (api - .net web api, db - PostgreSQL, rabbitmq, pgadmin). However, an additional ...
0
votes
0
answers
157
views
Migrate or convert SQL Server stored procedures and UDFs to PostgreSQL stored procedure and UDF
I came across with requirement where I have SQL Server database with tables, views, functions and stored procedures in the database. I am able to generate tables, export database to PostgreSQL, but ...
- 143
0
votes
0
answers
429
views
Issue with dates being set to UTC automatically
I have a system that pulls data from a PostgreSQL DB and writes it to SQL Server 2012. The field names are the same on both sides. PostgreSQL is delivered as part of a SaaS solution. (I only have read ...
- 1
0
votes
1
answer
1k
views
C# database classes to change between postgres and SQL Server
I am overthinking this and can't find the right terms to search on in Google.
I have a website that connects to a SQL Server database with mostly centralized classes to call out to the database.
I was ...
- 3,701
1
vote
1
answer
821
views
MSSQL and POSTGRESQL common string filter expression for the index - efcore code-first
I have a problem with HasFilter method.I could not configure the filter expression for Index in different databases.
This line just works with MSSQL
builder.HasIndex(p => new { p.Name, p.Id })
...
- 11
0
votes
1
answer
381
views
How to count number of BEGIN TRANSACTION statements in PostgreSQL?
using (DbConnection dbConn = myContext.Database.GetDbConnection()) {
using (DbCommand dbCommand = dbConn.CreateCommand()) {
dbCommand.CommandText = &...
- 475
1
vote
1
answer
448
views
Using 0 as Primary Key
I use lookup tables commonly and sometimes I have some default record in the Lookup table and I think for this record I can use 0 as Primary Key a as shown below:
Project:
Id | Name | ...
user5871859
0
votes
1
answer
2k
views
C# application to access data from PostgreSQL and SQL Server
What is the best way to go about accessing data from SQL Server and PostgreSQL databases in a single ASP.NET web application? I have a gridview that I would like to have columns of data from both ...
- 101
1
vote
0
answers
619
views
Synchronize SQL Server table and Postgres table
There is SQL Server database table which is source and Postgres database as destination table. Is there any efficient approach using C# to keep same data on postgres table side reflecting sql server ...
- 895
3
votes
0
answers
488
views
Bulk insert for multiple database providers
I'm completly new in donet and I'm trying to find a way to write database from c# into a db provider. The data stems from json files, which hold all necessary information for the insertion process (...
- 111
1
vote
1
answer
87
views
How can I register two database connections with nhibernate/lightcore?
I have to set up to the existing database(Ms Sql) another one(PostgreSql) with Fluent Nhibernate for my C# Mvc Applicaton. Someone know how can I register the postgreSql database in the ...
- 271
1
vote
1
answer
2k
views
Migrate EF6 database-first from SQL Server to PostgreSQL
I am looking for easy way to reuse edmx file created with EF6 over SQL Server to PostgreSQL
I have used database-first with EF6 on SQL Server and everything worked fine.
We are going to use ...
- 303
1
vote
1
answer
320
views
Store third party services login/password in database
My .NET Core application requires connections to a number of third party services.
Some of these services use login/password credentials, and this is a problem.
Application is cross-platform (Windows/...
- 37.8k