New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support for array types #15
Comments
This should definitely be supported, I'll take a look. |
This is actually a wider problem I ran into a while ago - how should array types be handled. In general, EF7 treats such properties as navigation properties; we need to check what happens if an entity has an array property (or more generally an IList property) over a type that isn't itself an entity. If these are simply ignored by the EF7 core then we can probably map these to PostgreSQL arrays. Either way we need to look at how EF7 normally handles this before tackling reverse engineering. |
Is this feature supported now ? I tried just now but still got an error : The 'PictureUris' is a column,of which the datatype is text[]. |
Nope, still not supported, there were more important things to do. I hope to take a look soon. |
I've committed support for arrays, I can see tables being created with int[] and can read and write. Still left:
|
Thank you for doing this great job,I tried and it takes effect. My English is very poor, so I’d like to express my gratitude with Chinese —— 谢谢! |
@tuoxieyz thanks for the kinds words :) The feature isn't completely done yet, but the basics are there. Please test and let me know of any issues! |
I'm still not able to insert with text arrays using the latest 1.0.2 off nuget.org. I've tried using string[], List and two different sql statements to manually insert with text arrays and they all fail. I created a repo to illustrate this here. https://github.com/NickAtEbsco/PostgresTextArray |
As the milestone shows, this has only been done for the 1.1.0 release, not 1.0.2. 1.1.0 is scheduled for release in November. Until then, if you're brave you can try the 1.1.0 CI nuggets from the Npgsql unstable feed. |
I just pulled it in and it appears to be working. I'll use that until November. Thanks for the response. |
Great to know it works for you, please let me know if you encounter any issues. |
Hello everyone. I'm trying to map a byte field [] to store an image, however I'm getting the error: Microsoft.EntityFrameworkCore.Infrastructure [10403] My Field: [Column("ESCR_BT_COMPROVANTE", TypeName = "bytea")] can you help me? |
From @eBerdnA on December 29, 2015 15:53
I just noticed that scaffolding a table which includes a column with datatype bytea[] can't be scaffolded. The following warning is generated.
I'm using a simple table like this.
Does this happen due to a limitation of the EntityFramework or due to an issue of npgsql?
Copied from original issue: npgsql/npgsql#926
The text was updated successfully, but these errors were encountered: