Name Collision

Open
#685 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
fsharp, sql
Domain
databases

Research direction

No files or tests are named. Start by reproducing the issue with the supplied SQL Server schema, then trace the SQL type provider's name-cleanup and member-generation logic. Done means the two columns no longer produce an overload collision, or the provider exposes a documented way to disable cleanup.

Written by the indexing model from the issue text.

Description

sql server

I’m trying to use the sql provider with our production ms sql database schema however I’ve found a problem which I can’t seem to work around. One of our table is badly constructed meaning with have ended up with the following:

CREATE TABLE [Account](
	[Id] [int] IDENTITY(1,1),
	[Billing_Address] [varchar](max) NULL,
	[BillingAddress] [varchar](max) NULL,
)

When the provider runs it is cleaning the underscore out of the the first Billing_Address and the provided throws an error:

The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: GetMethodImpl. not support overloads, name = 'get_BillingAddress', methods - '[|Method get_BillingAddress; Method get_BillingAddress|]', callstack = '" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

Sadly, I can’t change the production database so are there any options to disable the name clean up?

Dominant language
F#
Stars
627
Forks
147
Avg merge
2h 2m
Merged PRs (30d)
1

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from fsprojects/SQLProvider

All issues in fsprojects/SQLProvider

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.