Tuomas Hietanen comments

Results 463 comments of


                                            Tuomas Hietanen

SubmitUpdates Operation Order

I went for manual transaction handling. In .NET the default `TransactionScopeOption` is `Required` meaning SQLProvider should just commit to a transaction if you have one. This thread might help you...

Left join entity is never null

This is kind of duplicate of #540

... Unable to load one or more of the requested types ...

I think with type providers you should use compiletime the full .NET framework dll and runtime the Core dll.

... Unable to load one or more of the requested types ...

See: https://github.com/fsprojects/SQLProvider/tree/master/tests/SqlProvider.Core.Tests/MySql

... Unable to load one or more of the requested types ...

Hi, I upgraded few system references, to SQLProvider 1.1.79, hope that helped.

[SQL SERVER] Dealing with nulls values and timestamp columns during insert

What does your table look like? Do you have default values to columns?

[SQL SERVER] Dealing with nulls values and timestamp columns during insert

Ok, I was thinking if something like this could help: ```sql ALTER TABLE [dbo].[WriteStorages] ADD DEFAULT (getdate()) FOR [Version] GO ```

Intellisense failure and random errors after sometime (VS 2019)

Thanks for reporting. I'll try to see what goes wrong but I expect this one is not easy to debug.

Intellisense failure and random errors after sometime (VS 2019)

Did you have network connection lost? The TypeProvider SDK has been updated, is this still happening? Also, on runtime you can do simple manual reconnection like this: https://github.com/fsprojects/SQLProvider/issues/397#issuecomment-296618798

Provide access to the OracleConfiguration

Is this a design-time (static parameter) or runtime (parameter for GetDataContext-method) problem? I don't have an access to Oracle DB, but I can accept the PR if someone else creates...