René's URL Explorer Experiment


Title: Cannot parse to objects with enum properties · Issue #64 · improvedk/unQuery · GitHub

Open Graph Title: Cannot parse to objects with enum properties · Issue #64 · improvedk/unQuery

X Title: Cannot parse to objects with enum properties · Issue #64 · improvedk/unQuery

Description: If you have an object that has a property of type Enum, all get querys fail with a message like Property '[ColumnName]' with type '[Enumtype]' does not match column with the same name.. This is expected, since Enums aren't mentioned anyw...

Open Graph Description: If you have an object that has a property of type Enum, all get querys fail with a message like Property '[ColumnName]' with type '[Enumtype]' does not match column with the same name.. This is exp...

X Description: If you have an object that has a property of type Enum, all get querys fail with a message like Property '[ColumnName]' with type '[Enumtype]' does not match column with the same na...

Opengraph URL: https://github.com/improvedk/unQuery/issues/64

X: @github

direct link

Domain: patch-diff.githubusercontent.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cannot parse to objects with enum properties","articleBody":"If you have an object that has a property of type `Enum`, all get querys fail with a message like **Property '[ColumnName]' with type '[Enumtype]' does not match column with the same name.**.\nThis is expected, since Enums aren't mentioned anywhere in the docs.\n\nI tried to get around this by making a specific class specific for my query where i change the type of my Enum to a string, but this didn't work either.\n\nI Created a test that shows my problem. It should run in LinqPad or a Console.App\n\n``` c#\nvoid Main()\n{\n    var DB = new unQuery.unQueryDB(\"DB_Connection\");\n    using (var transScope = new TransactionScope())\n    {\n        // Create temp table and populate it\n        DB.Execute(@\"\n            IF NOT (EXISTS (SELECT * \n                 FROM INFORMATION_SCHEMA.TABLES \n                 WHERE TABLE_SCHEMA = 'dbo' \n                 AND  TABLE_NAME = 'EnumTest'))\n            BEGIN\n                CREATE TABLE EnumTest(\n                    ValueField1 NVARCHAR(30),\n                    ValueField2 NVARCHAR(30)\n                )\n\n                INSERT INTO EnumTest (ValueField1, ValueField2) VALUES ('EnumVal1', 'Bananas');\n                INSERT INTO EnumTest (ValueField1, ValueField2) VALUES ('EnumVal2', 'Phones');\n            END\n        \");\n\n        // Works\n        tryType\u003cObjectStringDTO\u003e(DB);\n        // Fails - Which is expected\n        tryType\u003cObjectEnumDTO\u003e(DB);\n        // Fails - But i would expect it to work\n        tryType\u003cObjectNewStringDTO\u003e(DB);\n    }\n\n}\n\nvoid tryType\u003cT\u003e(unQueryDB DB)\n{\n    try\n    {\n        Console.Write(DB.GetRows\u003cT\u003e(\"SELECT ValueField1, ValueField2  FROM EnumTest\"));\n    }\n    catch (Exception ex)\n    {\n        ex.Message.Dump();\n    }\n}\n\nenum MyEnum\n{\n    EnumVal1,\n    EnumVal2\n}\n\nclass ObjectStringDTO\n{\n    public string ValueField1 { get; set; }\n    public string ValueField2 { get; set; }\n}\n\nclass ObjectEnumDTO\n{\n    public MyEnum ValueField1 { get; set; }\n    public string ValueField2 { get; set; }\n}\n\nclass ObjectNewStringDTO : ObjectEnumDTO\n{\n    public new string ValueField1 { get; set; }\n}\n```\n","author":{"url":"https://github.com/boedlen","@type":"Person","name":"boedlen"},"datePublished":"2016-08-17T09:24:37.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/64/unQuery/issues/64"}

route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:0bf1ba65-376f-845e-d4c4-622128b25751
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idD9E8:363C53:3E65DB5:5114DBF:697DA751
html-safe-noncefb873717a3e3fc8727e2876c4f0b2138decda18ee0f1035b6baa5681e76a49d4
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEOUU4OjM2M0M1MzozRTY1REI1OjUxMTREQkY6Njk3REE3NTEiLCJ2aXNpdG9yX2lkIjoiMzMyNDE4ODE5MjE4MDkwNTgwOSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacb5dacfad19b3cdeec991a3a6fddab197d171d98d56a0e1a8a0c0242fc9b3fcb9
hovercard-subject-tagissue:171612530
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/improvedk/unQuery/64/issue_layout
twitter:imagehttps://opengraph.githubassets.com/70e5028a9a40b79cb3821b1a05a0f556d040a25af11cbf24c2d113f68ee80501/improvedk/unQuery/issues/64
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/70e5028a9a40b79cb3821b1a05a0f556d040a25af11cbf24c2d113f68ee80501/improvedk/unQuery/issues/64
og:image:altIf you have an object that has a property of type Enum, all get querys fail with a message like Property '[ColumnName]' with type '[Enumtype]' does not match column with the same name.. This is exp...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameboedlen
hostnamegithub.com
expected-hostnamegithub.com
None60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6
turbo-cache-controlno-preview
go-importgithub.com/improvedk/unQuery git https://github.com/improvedk/unQuery.git
octolytics-dimension-user_id732069
octolytics-dimension-user_loginimprovedk
octolytics-dimension-repository_id14315901
octolytics-dimension-repository_nwoimprovedk/unQuery
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id14315901
octolytics-dimension-repository_network_root_nwoimprovedk/unQuery
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release7c85641c598ad130c74f7bcc27f58575cac69551
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/improvedk/unQuery/issues/64#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fimprovedk%2FunQuery%2Fissues%2F64
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fimprovedk%2FunQuery%2Fissues%2F64
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=improvedk%2FunQuery
Reloadhttps://patch-diff.githubusercontent.com/improvedk/unQuery/issues/64
Reloadhttps://patch-diff.githubusercontent.com/improvedk/unQuery/issues/64
Reloadhttps://patch-diff.githubusercontent.com/improvedk/unQuery/issues/64
improvedk https://patch-diff.githubusercontent.com/improvedk
unQueryhttps://patch-diff.githubusercontent.com/improvedk/unQuery
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fimprovedk%2FunQuery
Fork 7 https://patch-diff.githubusercontent.com/login?return_to=%2Fimprovedk%2FunQuery
Star 10 https://patch-diff.githubusercontent.com/login?return_to=%2Fimprovedk%2FunQuery
Code https://patch-diff.githubusercontent.com/improvedk/unQuery
Issues 12 https://patch-diff.githubusercontent.com/improvedk/unQuery/issues
Pull requests 3 https://patch-diff.githubusercontent.com/improvedk/unQuery/pulls
Actions https://patch-diff.githubusercontent.com/improvedk/unQuery/actions
Projects 0 https://patch-diff.githubusercontent.com/improvedk/unQuery/projects
Security 0 https://patch-diff.githubusercontent.com/improvedk/unQuery/security
Insights https://patch-diff.githubusercontent.com/improvedk/unQuery/pulse
Code https://patch-diff.githubusercontent.com/improvedk/unQuery
Issues https://patch-diff.githubusercontent.com/improvedk/unQuery/issues
Pull requests https://patch-diff.githubusercontent.com/improvedk/unQuery/pulls
Actions https://patch-diff.githubusercontent.com/improvedk/unQuery/actions
Projects https://patch-diff.githubusercontent.com/improvedk/unQuery/projects
Security https://patch-diff.githubusercontent.com/improvedk/unQuery/security
Insights https://patch-diff.githubusercontent.com/improvedk/unQuery/pulse
New issuehttps://patch-diff.githubusercontent.com/login?return_to=https://github.com/improvedk/unQuery/issues/64
New issuehttps://patch-diff.githubusercontent.com/login?return_to=https://github.com/improvedk/unQuery/issues/64
Cannot parse to objects with enum propertieshttps://patch-diff.githubusercontent.com/improvedk/unQuery/issues/64#top
https://github.com/boedlen
https://github.com/boedlen
boedlenhttps://github.com/boedlen
on Aug 17, 2016https://github.com/improvedk/unQuery/issues/64#issue-171612530
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.