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
Domain: patch-diff.githubusercontent.com
{"@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-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:0bf1ba65-376f-845e-d4c4-622128b25751 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | D9E8:363C53:3E65DB5:5114DBF:697DA751 |
| html-safe-nonce | fb873717a3e3fc8727e2876c4f0b2138decda18ee0f1035b6baa5681e76a49d4 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEOUU4OjM2M0M1MzozRTY1REI1OjUxMTREQkY6Njk3REE3NTEiLCJ2aXNpdG9yX2lkIjoiMzMyNDE4ODE5MjE4MDkwNTgwOSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | b5dacfad19b3cdeec991a3a6fddab197d171d98d56a0e1a8a0c0242fc9b3fcb9 |
| hovercard-subject-tag | issue:171612530 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/improvedk/unQuery/64/issue_layout |
| twitter:image | https://opengraph.githubassets.com/70e5028a9a40b79cb3821b1a05a0f556d040a25af11cbf24c2d113f68ee80501/improvedk/unQuery/issues/64 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/70e5028a9a40b79cb3821b1a05a0f556d040a25af11cbf24c2d113f68ee80501/improvedk/unQuery/issues/64 |
| og:image:alt | 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... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | boedlen |
| hostname | github.com |
| expected-hostname | github.com |
| None | 60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6 |
| turbo-cache-control | no-preview |
| go-import | github.com/improvedk/unQuery git https://github.com/improvedk/unQuery.git |
| octolytics-dimension-user_id | 732069 |
| octolytics-dimension-user_login | improvedk |
| octolytics-dimension-repository_id | 14315901 |
| octolytics-dimension-repository_nwo | improvedk/unQuery |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 14315901 |
| octolytics-dimension-repository_network_root_nwo | improvedk/unQuery |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 7c85641c598ad130c74f7bcc27f58575cac69551 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width