ORM

Started by marceloover 7 years ago7 messagesgeneral
Jump to latest
#1marcelo
marcelo.nicolet@gmail.com

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set to
an instance of an object" exceptions or other more specific to this
libraries.
I would wish to change the ORM.
Some experiences would be appreciated. Of course, I prefer open source
software, at least to chase errors thru debugging.
TIA

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: marcelo (#1)
Re: ORM

On 9/28/18 3:49 PM, marcelo wrote:

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set to
an instance of an object" exceptions or other more specific to this
libraries.
I would wish to change the ORM.
Some experiences would be appreciated. Of course, I prefer open source
software, at least to chase errors thru debugging.

Information that might help folks steer you to alternatives:

1) What programming language(s) are you using?

2) The OS'es involved

3) Are you using any frameworks between the database and the end user?

4) Is an ORM even necessary?

TIA

---
El software de antivirus Avast ha analizado este correo electrónico en
busca de virus.
https://www.avast.com/antivirus

--
Adrian Klaver
adrian.klaver@aklaver.com

#3marcelo
marcelo.nicolet@gmail.com
In reply to: Adrian Klaver (#2)
Re: ORM

On 28/09/2018 21:39 , Adrian Klaver wrote:

On 9/28/18 3:49 PM, marcelo wrote:

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set
to an instance of an object" exceptions or other more specific to
this libraries.
I would wish to change the ORM.
Some experiences would be appreciated. Of course, I prefer open
source software, at least to chase errors thru debugging.

Information that might help folks steer you to alternatives:

1) What programming language(s) are you using?

/C#, from 4.5 framework./

2) The OS'es involved

/Linux for the database server, Windows for client machines.//
/

//
3) Are you using any frameworks between the database and the end user?

/Yes, a very big one, developed by me (or using open source libraries at
some spots), which tries to implement MVP pattern. It´s near completely
agnostic regarding the DAL layer, but I cannot deny that it may be
somewhat influenced by the Devart´s model.//
/

//
4) Is an ORM even necessary?

/Yes; there are around 50 entities and with lots of foreign keys. It´s
well worth to have pre-plumbed the code to get "fathers" and "child
collections". Ah, and I´m working alone./

TIA

---
El software de antivirus Avast ha analizado este correo electrónico
en busca de virus.
https://www.avast.com/antivirus

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus

#4Adrian Klaver
adrian.klaver@aklaver.com
In reply to: marcelo (#3)
Re: ORM

On 9/29/18 6:47 AM, marcelo wrote:

On 28/09/2018 21:39 , Adrian Klaver wrote:

On 9/28/18 3:49 PM, marcelo wrote:

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set
to an instance of an object" exceptions or other more specific to
this libraries.
I would wish to change the ORM.
Some experiences would be appreciated. Of course, I prefer open
source software, at least to chase errors thru debugging.

Information that might help folks steer you to alternatives:

1) What programming language(s) are you using?

/C#, from 4.5 framework./

Have you looked at:

http://www.npgsql.org/

2) The OS'es involved

/Linux for the database server, Windows for client machines.//
/

//
3) Are you using any frameworks between the database and the end user?

/Yes, a very big one, developed by me (or using open source libraries at
some spots), which tries to implement MVP pattern. It´s near completely
agnostic regarding the DAL layer, but I cannot deny that it may be
somewhat influenced by the Devart´s model.//
/

//
4) Is an ORM even necessary?

/Yes; there are around 50 entities and with lots of foreign keys. It´s
well worth to have pre-plumbed the code to get "fathers" and "child
collections". Ah, and I´m working alone./

TIA

---
El software de antivirus Avast ha analizado este correo electrónico
en busca de virus.
https://www.avast.com/antivirus

<https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient&gt;
Libre de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient&gt;

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

--
Adrian Klaver
adrian.klaver@aklaver.com

#5Edson Carlos Ericksson Richter
richter@simkorp.com.br
In reply to: marcelo (#1)
Re: ORM

Em 28/09/2018 19:49, marcelo escreveu:

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set to
an instance of an object" exceptions or other more specific to this
libraries.
I would wish to change the ORM.
Some experiences would be appreciated. Of course, I prefer open source
software, at least to chase errors thru debugging.
TIA

---
El software de antivirus Avast ha analizado este correo electrónico en
busca de virus.
https://www.avast.com/antivirus

For .Net I know nothing.
For Java, at other side, EclipseLink is fantastic.

Regards,

Edson.

#6Dmitriy Igrishin
dmitigr@gmail.com
In reply to: marcelo (#1)
Re: ORM

сб, 29 сент. 2018 г. в 1:50, marcelo <marcelo.nicolet@gmail.com>:

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set to
an instance of an object" exceptions or other more specific to this
libraries.
I would wish to change the ORM.

The best ORM is vanila SQL.

#7marcelo
marcelo.nicolet@gmail.com
In reply to: Edson Carlos Ericksson Richter (#5)
Re: ORM

On 29/09/2018 16:09 , Edson Carlos Ericksson Richter wrote:

Em 28/09/2018 19:49, marcelo escreveu:

For a new big and convoluted project I (am/was) using Devart´s
LinqConnect as ORM.
But today I experienced some inexplicable "object reference not set
to an instance of an object" exceptions or other more specific to
this libraries.
I would wish to change the ORM.
Some experiences would be appreciated. Of course, I prefer open
source software, at least to chase errors thru debugging.
TIA

---
El software de antivirus Avast ha analizado este correo electrónico
en busca de virus.
https://www.avast.com/antivirus

For .Net I know nothing.
For Java, at other side, EclipseLink is fantastic.

Regards,

Edson.

Thank you. Do you know about a porting to .NET?

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus