Object Persistence
-
Hi everyone. I want to know from you guys what approach you're using to persist an object into the SQL Server database? I and some work mates are discussing about the best approach of doing this for our next project, but we don't have much information or experience about the subject, so any information would be welcomed. Thanks in advance
-
Hi everyone. I want to know from you guys what approach you're using to persist an object into the SQL Server database? I and some work mates are discussing about the best approach of doing this for our next project, but we don't have much information or experience about the subject, so any information would be welcomed. Thanks in advance
pontonet wrote:
I want to know from you guys what approach you're using to persist an object into the SQL Server database?
INSERT statements usually do it for me. I think you need to provide more detail. For example, are you talking about ORM? Just any type of object? Or do you need to turn an existing object model in to a relational model?
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
pontonet wrote:
I want to know from you guys what approach you're using to persist an object into the SQL Server database?
INSERT statements usually do it for me. I think you need to provide more detail. For example, are you talking about ORM? Just any type of object? Or do you need to turn an existing object model in to a relational model?
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
I meant better approaches, for instance, NHibernate, and so on. Technologies that does it almost automatically for you, without needing to write much SQL code directly.
pontonet wrote:
I meant better approaches, for instance, NHibernate, and so on.
ORM tools then.
pontonet wrote:
Technologies that does it almost automatically for you, without needing to write much SQL code directly.
Ah, well... Can't help you if you are looking for ORM tools. I'm a big fan of creating stored procedures and a DAL that is a proxy for the stored procedure. I don't advocate exposing tables directly on the grounds that it is a security risk. Although, having said that some ORM tools do make better allowances for stored procedures LLBLGen I believe is one.
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website