Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Data Type > Save various object types

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-02-14 : 06:11:28
Hello,

I am working on a .NET project and I would like to save some LOCALIZED content in an SQL 2005 database.

This content might be a string, a number or even a class with its properties values defined so I can retrieve it later.

I will not need search or any complex operation just the following:
1. Add content to the database
2. Remove content from the database by contentId
3. Get content from the database by contentId

Anyway, is this possible?

What SQL 2005 datatype should I use to accomplish this?

Thanks,
Miguel

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-14 : 06:13:45
Are you talking about serializing the objects in SQL Server database?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-02-14 : 06:19:37
I don't understand exactly the meaning or consequences of serializing the objects.
I know that is used in ASP.NET 2.0 to save profiles since these are classes.

I suspected this was the way but I as I said I am not sure why and how.

Thanks,
Miguel

Go to Top of Page
   

- Advertisement -