chrismh / simple.data.postgresql Goto Github PK

View Code? Open in Web Editor NEW

9.0 9.0 10.0 1.72 MB

PostgreSQL provider for Simple.Data

PowerShell 0.54% C# 94.23% PLpgSQL 5.23%

simple.data.postgresql's People

Contributors

Stargazers

Watchers

Forkers

kppullin yodeski fishman terzano robertwilczynski ultrico pako1337 danbarua yartat btubak

simple.data.postgresql's Issues

Get() call with eager loading not working

Hi,
If you will try to do something like

Element element = db.Elements
    .WithContents()
    .Get(ElementId);

you will end up with slightly incorrect query:

select 
"public"."Elements"."ElementId",
"public"."Contents"."ContentId" AS "__withn__Contents__ContentId",
"public"."Contents"."ElementId" AS "__withn__Contents__ElementId",
from "public"."Elements"
LEFT JOIN "public"."Contents"
ON ("public"."Elements"."ElementId" = "public"."Contents"."ElementId")
WHERE "public"."Elements"."ElementId" = ((1))
LIMIT 1 OFFSET 0

Notice LIMIT 1 OFFSET 0 part at the end - only one row will get returned, while I would expect to get all related rows. I.e. eager loading when using Get() (and probably when using First, FirstOrDefault, Single and SingleOrDefault) is broken.

Error trying to load PgProcedureExecutor on Mono 3.8

When trying to load a simple Nancy server, I get this error.

System.TypeLoadException
Could not load type 'Simple.Data.PostgreSql.PgProcedureExecutor' from assembly 'Simple.Data.PostgreSql, Version=0.17.0.0, Culture=neutral, PublicKeyToken=null'.

Description: HTTP 500.Error processing request.
Details: Non-web exception. Exception origin (name of application or object): mscorlib.
Exception stack trace:
  at (wrapper managed-to-native) System.MonoType:GetPropertiesByName (System.MonoType,string,System.Reflection.BindingFlags,bool,System.Type)
  at System.MonoType.GetProperties (BindingFlags bindingAttr) [0x00000] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/corlib/System/MonoType.cs:318 
  at System.ComponentModel.Composition.AttributedModel.AttributedPartCreationInfo+<GetExportMembers>c__Iterator0.MoveNext () [0x00110] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.ComponentModel.Composition.4.5/src/ComponentModel/System/ComponentModel/Composition/AttributedModel/AttributedPartCreationInfo.cs:358 
  at System.Linq.Enumerable.Any[MemberInfo] (IEnumerable`1 source) [0x00024] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.Core/System.Linq/Enumerable.cs:138 
  at System.ComponentModel.Composition.AttributedModel.AttributedPartCreationInfo.HasExports () [0x00000] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.ComponentModel.Composition.4.5/src/ComponentModel/System/ComponentModel/Composition/AttributedModel/AttributedPartCreationInfo.cs:113 
  at System.ComponentModel.Composition.AttributedModel.AttributedPartCreationInfo.IsPartDiscoverable () [0x0001d] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.ComponentModel.Composition.4.5/src/ComponentModel/System/ComponentModel/Composition/AttributedModel/AttributedPartCreationInfo.cs:94 
  at System.ComponentModel.Composition.AttributedModel.AttributedModelDiscovery.CreatePartDefinitionIfDiscoverable (System.Type type, ICompositionElement origin) [0x0000a] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.ComponentModel.Composition.4.5/src/ComponentModel/System/ComponentModel/Composition/AttributedModel/AttributedModelDiscovery.cs:20 
  at System.ComponentModel.Composition.Hosting.TypeCatalog.get_PartsInternal () [0x00052] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.ComponentModel.Composition.4.5/src/ComponentModel/System/ComponentModel/Composition/Hosting/TypeCatalog.cs:276 
  at System.ComponentModel.Composition.Hosting.TypeCatalog.CreateIndex () [0x0000b] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/System.ComponentModel.Composition.4.5/src/ComponentModel/System/ComponentModel/Composition/Hosting/TypeCatalog.cs:328 
  at System.Lazy`1[System.Collections.Generic.IDictionary`2[System.String,System.Collections.Generic.List`1[System.ComponentModel.Composition.Primitives.ComposablePartDefinition]]].InitValue () [0x0015f] in /Volumes/build-root-ramdisk/mono-3.8.0/mcs/class/corlib/System/Lazy.cs:164 
Version Information: 3.8.0 ((no/db71bc1 Fri Sep 12 13:10:47 EDT 2014); ASP.NET Version: 4.0.30319.17020

Update to latest Simple.Data release

Chris, I was wondering if you are still actively maintaining this project and had plans to support the latest releases of Simple.Data?
I started using PosgreSQL more frequently and really appreciate the effort being put into this project.

Best Regards,
Diego.

Any plans to support new versions of PostgreSQL

Hi, I was wondering if this project is still being maintained. Do you need contributors?
Any hopes of getting current support for the new features of PostgreSQL 9.4?

Thanks.

Still active?

Hi there,

Is this still being maintained? I am looking into this for Postgres with jsonb column type. Is this supported?

ExecuteReader is not implemented

I have a simple database with a "User" table.

When I run this:
Database.Open().User.FindByName("Chris")

I get an exception with the following explanation:
"Method 'ExecuteReader' in type 'Simple.Data.PostgreSql.PgProcedureExecutor' from assembly 'Simple.Data.PostgreSql, Version=0.16.2.2, Culture=neutral, PublicKeyToken=null' does not have an implementation.":"Simple.Data.PostgreSql.PgProcedureExecutor"

Upon inspection of the PgProcedureExecutor.cs class, I see that indeed, ExecuteReader is not implemented. It seems to be used after all.

Unable to get generated sql trace output to show (Simple.Data 0.14)

Hi, I've been using your provider for Simple.Data 0.14 and I can't seem to be able to make the process log the generated sql statements to the trace or debug console. Is this a known limitation, or am I forgetting something obvious?

Does not seem to work with Npgsql 3.x

Per this thread, I think that the current NuGet package of Simple.Data.PostgreSql (0.17.0.0) should have an additional dependency on Npgsql with the version set to 2.0.11 to 2.2.7.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.