rifftheraff Comments - Answer Overflow

rifftheraff

Posts Comments

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

49 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

Check following solution: https://stackoverflow.com/questions/75120980/vs2022-net-maui-blazor-start-with-without-debugging-causes-devenv-exe-to-cra

49 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

49 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

49 replies

CC#

•Created by oe on 1/23/2023 in #help

Compressing JSON data for SQL server, best way?

I would try not compress the JSON data. Insert it as it is as JSON. SQL server has built in JSON support to query that data. If you compress the data before inserting it, SQL server is not able to query information out of the JSON data structure. It can only retrieve the full compressed blob. This fully depends on your requirements. Example (from https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver16):

SELECT Name, Surname,
  JSON_VALUE(jsonCol, '$.info.address.PostCode') AS PostCode,
  JSON_VALUE(jsonCol, '$.info.address."Address Line 1"') + ' '
  + JSON_VALUE(jsonCol, '$.info.address."Address Line 2"') AS Address,
  JSON_QUERY(jsonCol, '$.info.skills') AS Skills
FROM People
WHERE ISJSON(jsonCol) > 0
  AND JSON_VALUE(jsonCol, '$.info.address.Town') = 'Belgrade'
  AND Status = 'Active'
ORDER BY JSON_VALUE(jsonCol, '$.info.address.PostCode')

SELECT Name, Surname,
  JSON_VALUE(jsonCol, '$.info.address.PostCode') AS PostCode,
  JSON_VALUE(jsonCol, '$.info.address."Address Line 1"') + ' '
  + JSON_VALUE(jsonCol, '$.info.address."Address Line 2"') AS Address,
  JSON_QUERY(jsonCol, '$.info.skills') AS Skills
FROM People
WHERE ISJSON(jsonCol) > 0
  AND JSON_VALUE(jsonCol, '$.info.address.Town') = 'Belgrade'
  AND Status = 'Active'
ORDER BY JSON_VALUE(jsonCol, '$.info.address.PostCode')

SQL server also has build in support for compress/decompress. Check article https://techcommunity.microsoft.com/t5/sql-server-blog/storing-json-in-sql-server/ba-p/384576 What is your requirement for compression? Faster transport, DB space, ...?

18 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

49 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

The simplest solution is to deploy your app as a app package (MSIX) (project template in Visual Studio) and define the windows.shareTarget extension in the package manifest file.

49 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

Are you using Visual Studio for development?

49 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

My main app is also a WPF app. Is it a professional app or some app for private use. Are you writing the app from scratch or is it already in use? How is it currently deployed to PCs?

49 replies

CC#

•Created by davidtran49 on 1/22/2023 in #help

❔ Help for a Test

Du hättest ChatGPT fragen sollen 👎 Wie gesagt, hier gibt es keine Hilfe beim Schummeln!

5 replies

CC#

•Created by jacobh12349 on 1/23/2023 in #help

❔ Add app to share menu

Yes it is possible. But their is no good documentation how to do it. I have done it a few weeks ago and it somehow works. But I also needed Explorer context menu integration .... What I can tell in short is you have to create a App package for your application (MSIX) that has do be installed. The app package tells Windows the extensions your app supports (ex. uap:Extension Category="windows.shareTarget" that your app supports sharing). I can tell you more later if you wish.

49 replies

Gaming

Programming