So then if we want to actually make this query work and have the ability to use Pascal case naming (such as MyTable), we need to use double quotes in our SQL query string.īut then arises the problem of C# not allowing these quotes as it breaks the string. Therefore again your example query above fails. Since there is no lowercase mytable in the database your query will return an error that MyTable does not exist.Įven if we omit the double quotes when creating the MyTable (not use pgAdmin or Navicat or write the table creation script our self without quotes), MyTable will actually be created as mytable. However, your query example does not use the double quotes around MyTable, which means it will be processed by Postgres as lowercase. then MyTable is created with double quotes “MyTable” which makes it case sensitive. If they were created using the default of most database tools, example pgAdmin4, Navicat etc. One big gotcha with using Postgres, that needs to be said.īased on your example code, how was your MyTable and it’s columns created? That also seems to get asked a lot, “OK so this can talk to MySQL but can it talk to MySQL from Linux”… errr… yes, yes it can! NET Core apps running inside Linux (Containers and VM’s) with absolutely no issue. I would also add that for both MySQL and Postgres, I’ve had. But in my experience, when using something like Dapper that allows you to really control the queries you are running, it really doesn’t make a heck of a lot of difference between any SQL Server. Maybe if you’re overlaying something like EF Core or a very heavy ORM you might have issues. NET Core’s point of view is to run simple commands.
The amount of time I’ve spent on calls trying to explain it really doesn’t matter for the most part which tech choice they go with if all they are expecting from.
NET Core to talk to anything non-Microsoft. The thing that gets me is often these companies are so wary about the ability for. NET Core, but don’t want to use Microsoft SQL Server – so they either want to use PostgreSQL or MYSQL. I contract/freelance out a lot to companies that are dipping their toes into.
0 kommentar(er)
