Microsoft.SqlServer.Types | NET Standard implementation of the spatial types | Map library

by dotMorten C# Version: release/v2.4 License: Apache-2.0

X-Ray Key Features Code Snippets(1)Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | Microsoft.SqlServer.Types Summary

Microsoft.SqlServer.Types is a C# library typically used in Geo, Map applications. Microsoft.SqlServer.Types has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

a .NET Standard implementation of the spatial types in Microsoft.SqlServer.Types.

Support

Quality

Security

License

Reuse

Support

Microsoft.SqlServer.Types has a low active ecosystem.

It has 56 star(s) with 23 fork(s). There are 5 watchers for this library.

It had no major release in the last 12 months.

There are 6 open issues and 41 have been closed. On average issues are closed in 225 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of Microsoft.SqlServer.Types is release/v2.4

Quality

Microsoft.SqlServer.Types has no bugs reported.

Security

Microsoft.SqlServer.Types has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

Microsoft.SqlServer.Types is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

Microsoft.SqlServer.Types releases are available to install and integrate.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of Microsoft.SqlServer.Types

Get all kandi verified functions for this library.

Microsoft.SqlServer.Types Key Features

No Key Features are available at this moment for Microsoft.SqlServer.Types.

Microsoft.SqlServer.Types Examples and Code Snippets

Examples

Lines of Code : 8

License : Permissive (Apache-2.0)

Copy

   command.Parameters.AddWithValue("@GeographyColumn", mySqlGeography);
   command.Parameters["@GeometryColumn"].UdtTypeName = "Geography";

   command.Parameters.AddWithValue("@GeographyColumn", mySqlGeometry);
   command.Parameters["@GeometryColumn

Community Discussions

Trending Discussions on Microsoft.SqlServer.Types

DbGeography.FromText - Unable to load DLL 'SqlServerSpatial140.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

PetaPoco Fails to Pull Geography Records

UWP app and SqlServerSpatial140.dll of microsoft.sqlserver.types issue

C# Save String To Database As Geometry

Referencing DLLs from a VB.Net DLL

Errors converting Geometry to Geography

Bulk Insert with NTS geometries in .NET Core

Azure pipeline: msbuild does not copy one DLL in _PublishedWebsites

Microsoft.SqlServer.Types exception on my dev machine

Install Microsoft.SqlServer.Types in GAC

QUESTION

DbGeography.FromText - Unable to load DLL 'SqlServerSpatial140.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Asked 2022-Jan-27 at 08:55

I have tried to copy spatial140 from packages folder "\packages\Microsoft.SqlServer.Types...\nativeBinaries", in Visual Studio build is a success, not found some error.

But when run the project, I got that error.

...

ANSWER

Answered 2022-Jan-27 at 08:55

Try to Change the status of spatial140.dll to Copy if newandContent.

Source https://stackoverflow.com/questions/70872575

QUESTION

PetaPoco Fails to Pull Geography Records

Asked 2021-Dec-14 at 21:36

I'm using C#, .NET framework 4.5 (with intentions to upgrade to .NET 5), and PetaPoco as my ORM.

I have a table named Jurisdiction with the following field definition:

...

ANSWER

Answered 2021-Dec-14 at 21:36

I was ultimately able to resolve my issue, though it was very much involved. In my query, instead of doing a SELECT * I had to spell out each column and manually convert the geography value using:

Source https://stackoverflow.com/questions/70341931

QUESTION

UWP app and SqlServerSpatial140.dll of microsoft.sqlserver.types issue

Asked 2021-Nov-29 at 07:05

I have UWP app that has reference to the Microsoft.Sqlserver.Types via Nuget and inside has the code

...

ANSWER

Answered 2021-Nov-29 at 07:05

Here is the asnwer Unable to load DLL 'SqlServerSpatial140.dll': The specified module could not be found

We have to include both DLLs from

Source https://stackoverflow.com/questions/70150612

QUESTION

C# Save String To Database As Geometry

Asked 2021-Oct-26 at 14:42

Right now we are getting the geometry data as a string, and we need to save it to our SQL DB as a Geometry type.

Currently, I'm trying to do something that looks like this

...

ANSWER

Answered 2021-Oct-26 at 14:42

Parameters in SQL queries are used to prevent SQL injection - that means nothing you include in a parameter to your query will be treated as anything other than data, it won't be evaluated, so geometry::Parse will not run. Try something like this:

Source https://stackoverflow.com/questions/69724812

QUESTION

Referencing DLLs from a VB.Net DLL

Asked 2021-Oct-15 at 07:31

I've got a Visual Studio solution that I'm trying to test a deploy for. The solution has multiple projects in it and references a bunch of different components from the .Net framework and elsewhere. All of my components are in C#, except one which is in VB.Net (will get upgraded at some point, but needs to be done in one shot and is large).

The project structure is:

Everything works well on my dev machine. However, when I deploy to a test machine, which is Windows 10 + updates, and purposely no internet connection (a valid test), I get an issue when running part of the program within the Dolphin component.

The code erroring on the test machine is:

...

ANSWER

Answered 2021-Oct-11 at 14:18

I would not think this has much to do with c# vs VB.Net, once built there should only be .Net assemblies, and it should not matter what language that was used.

The correct solution should be to register a nuget dependency on Microsoft.SqlServer.Types for the project that needs this assembly. I.e. go to "Tools\Nuget Package Manager\Manage packages for solution" and install the package above in your dolphin project.

This should ensure that the needed dlls are downloaded from the internet and copied to your output directory, but you might need to include manually it if your are using any kind of installation framework.

Source https://stackoverflow.com/questions/69525936

QUESTION

Errors converting Geometry to Geography

Asked 2021-Aug-12 at 18:16

I am getting an error trying to convert data from a Geometry field to a geography field in a separate table.

...

ANSWER

Answered 2021-Aug-12 at 18:16

The relevant part of the error message is "A common reason for this error is that a polygon has the wrong ring orientation."

The polygons that have failed are in clockwise order.

To convert them to counter-clockwise order, you can use something like this:

Source https://stackoverflow.com/questions/68632742

QUESTION

Bulk Insert with NTS geometries in .NET Core

Asked 2021-Jul-15 at 07:29

As you probably know, inserting data into a table the "Entity Framework"-way is incredibly slow when you try to insert a lot of rows. One other way is to use SqlBulkCopy which does a great job of increasing performance. The problem is that SqlBulkCopy (from what I've read and tested) doesn't support the SQL geometry type in .NET Core.

This is in EF Core and the C# property type is an NTS Geometry which cannot be changed.

Using the old library Microsoft.SqlServer.Types is not an option because they don't work in .NET Core. The data is currently loaded as NTS Geometry from another SQL Server database.

Has anyone found an efficient way to insert many rows?

...

ANSWER

Answered 2021-Jul-14 at 12:48

Disclaimer: I'm the owner of Entity Framework Extensions

As you probably know inserting data into a table the "Entity Framework"-way is incredibly slow

That's true and this is the main reason why we created our library (paid library).

Our library support context.BulkInsert through Entity Framework and supports SQL Geometries as well.

That being said, this is also possible to do it directly through SqlBulkCopy.

For EF Core, you need to convert your value using a SqlServerBytesWriter.

Here is a full example:

Source https://stackoverflow.com/questions/68377899

QUESTION

Azure pipeline: msbuild does not copy one DLL in _PublishedWebsites

Asked 2021-Jul-06 at 15:37

I have a strange behavior with msbuild on my Azure Pipeline. I'm using Azure Pipeline with Self-hosted Windows agents.

Configuration:

My Visual Studio .sln contains two C# projects:

WebService (Rest API)
Business layer

In addition, the Business layer has dependencies on 2 others projects.

Kernel.DataModel
Kernel.DataAccess

The Kernel.DataAcess layer is using the NuGet package "Microsoft.SqlServer.Types" (14.0.314.76)

The Reference "Microsoft.SqlServer.Types" in the project Kernel.DataAccess has "Copy Local = True". Therefore the DLL file should be copied in the output (release) directory.

The problem:

When I run the Azure Build pipeline, the file "Microsoft.SqlServer.Types.dll" is not copied in the "_PublishedWebsites" directory.

To convince myself, I decided to run the same Pipeline on another build machine by changing the Agent Pool. At my surprise the DLL was present in the "_PublishedWebsites" on the second build machine.

Furthermore, I decided to manually run the msbuild command on my local computer and the the DLL was also present in the "_PublishedWebsites...\bin" on my local machine.

Log files:

I also looked at log files on the Build machines and on my local computer.

First build machine -> The DLL file is simply not copied !
Second build machine -> The DLL file is copied from this location.

...

ANSWER

Answered 2021-Jul-06 at 15:37

Is it possible that your *.csproj is targetting the wrong HintPath?

Could you check if you have something like this:

Source https://stackoverflow.com/questions/68231434

QUESTION

Microsoft.SqlServer.Types exception on my dev machine

Asked 2021-Apr-30 at 12:00

In my team, a dev recently updated our project to use EF6. All my colleagues can run the projet whitout problems, but in my machine, I'm getting the error:

"Spatial types and functions are not available for this provider because the assembly 'Microsoft.SqlServer.Types' version 10 or higher could not be found."

This package is not even being used in the project, no one of my team even has the dll in the project.

I cant seem to find out what is wrong with this.

Can anyone help me?

Using Visual Studio 19.6.3 and SQL Server Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 Standard 6.2 (Build 9200: ) (Hypervisor)

...

ANSWER

Answered 2021-Apr-30 at 12:00

To solve the problem, you need SQL Server installed in your machine.

If you have windows 10 in your system, check if you have SQL Server installed in Apps and features.

You can also check if you have any version of Microsoft.SqlServer.Types in your GAC_MSIL (Global Assembly Cache) directory on C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Types, if this folder is empty or does not exist, you will need to install Microsoft.SqlServer.Types in your machine.

Source https://stackoverflow.com/questions/67008682

QUESTION

Install Microsoft.SqlServer.Types in GAC

Asked 2021-Apr-22 at 12:27

How do I install Microsoft.SqlServer.Types assembly in GAC (C:\Windows\assembly\GAC_MSIL). It is missing.

I am getting error after running rdlc report. it is MVC based application-

Could not load file or assembly 'Microsoft.SqlServer.Types, Version=12.0.0.0, Culture=neutral, PublicKeyToken=token' or one of its dependencies.

It seems application is looking Microsoft.SqlServer.Types assembly in GAC. I know how to install using nuget in project folder but I want it in GAC.

...

ANSWER

Answered 2021-Apr-22 at 12:27

Don’t try to GAC it. Add the NuGet package to your project instead.

https://www.nuget.org/packages/Microsoft.SqlServer.Types

Source https://stackoverflow.com/questions/67213151

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install Microsoft.SqlServer.Types

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: