Hi, I have a custom data structure which I use in .Net (C# or VB). And it consist of following data types

Structure Customer

CustID (int)

CustName (String)

CustLocation (String)

And the traditional way of saving the data is to Create a table with the above attributes and save each attribute to the relevant field. But What I really like to know is the following.

Instead of saving each filed, is there a way of defining the above structure on the SQL Table and save the Customer Object to that table. If there's a way of doing it, please explain..

I am using MS SQL 2005 and Visual Studio 2005 

Thanks in Advance

You could create CLR data types using Visual Studio and import them into SQL Server 2005. CLR user-defined types are like .NET objects that can be used to store data in SQL Server.

Try the following links:

• http://msdn.microsoft.com/en-us/library/ms186366.aspx
• http://msdn.microsoft.com/en-us/library/ms131120.aspx

Gogula G. Aryalingam (MVP - SQL Server)

Gogula G. Aryalingam:

You could create CLR data types using Visual Studio and import them into SQL Server 2005. CLR user-defined types are like .NET objects that can be used to store data in SQL Server.

Try the following links:

• http://msdn.microsoft.com/en-us/library/ms186366.aspx
• http://msdn.microsoft.com/en-us/library/ms131120.aspx