473,396 Members | 1,891 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Yukon & .Net v2

Jon
Hola all,

I've been pretty excited reading about the object features that are going into the next version of SQL Server. In short, you will be able to natively add objects as User defined types and use them as you would within any other .Net assembly.

So what I'm looking for is some sort of best-practice document that explores the design implications of this. Any oo developer that does a lot of database-centric design has probably built a class factory that does nothing more than query the database and return instances of objects, as well as saves changes back to the SQL server. It would seem that Yukon can replace much of this tedium.

- What's the best way to go about this, in general
- Specifically (I'll use a class called Address for the sake of this discussion), should data be serialized in a single column of type [Address], the traditional column design (name, address, city, etc.), both, or other?
- How would one manage diferent releases of the Address class that exposed different properties in a production environment?

Jul 21 '05 #1
1 1545
Jon,
Erik,

I suggest to post this question to one of the Whidbey groups:

<URL:http://communities.microsoft.com/newsgroups/default.asp?icp=whidbey>

Infos on how to view these groups with an NNTP news client:

<URL:http://communities.microsoft.com/new...US/welcomePage.
htm>

--
Cor

I've been pretty excited reading about the object features that are going into the next version of SQL Server. In short, you will be able to natively
add objects as User defined types and use them as you would within any other
..Net assembly.
So what I'm looking for is some sort of best-practice document that explores the design implications of this. Any oo developer that does a lot
of database-centric design has probably built a class factory that does
nothing more than query the database and return instances of objects, as
well as saves changes back to the SQL server. It would seem that Yukon can
replace much of this tedium.
- What's the best way to go about this, in general
- Specifically (I'll use a class called Address for the sake of this discussion), should data be serialized in a single column of type [Address],
the traditional column design (name, address, city, etc.), both, or other? - How would one manage diferent releases of the Address class that exposed different properties in a production environment?

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Lorenzo Braidi | last post by:
Hallo everyone, is there someone who is partecipating to the Microsoft Yukon Beta test and who can send me some picture of the new GUI of Enterprise Manager and Query Analyser? Send it at my...
1
by: Jack Victor | last post by:
Hi, Can anyone please tell me if there will be support in SQL2005 - Yukon for datafiles to be placed on Compressed volumes or if there will be compression of the data that is transparent to the...
0
by: Roberto Barrantes | last post by:
I installed Yukon Beta 2 in a computer with windows server 2003 when I tried to create a Data Transformation Project I got the following error: Failed to open package file "C:\Documents and...
6
by: James Liu | last post by:
I did some search and didn't find anything about whether Yokon will support sequence object. Appreciate it if you can reply with some resources. Thanks, James
0
by: Jay | last post by:
Hi, I am trying to reinstall YUKON beta 2 after uninstalling it. Now I'm getting error when it tries to install the SQL Server components and the message said that the login failed using 'sa'....
15
by: nospam | last post by:
Once Yukon is released (whenever that might be) does anyone from MS have any comment on licensing for Yukon and on SQL 2000. I really don't think anyone with SQL 2000 licenses are going to...
52
by: malcolm | last post by:
Here are a couple of dramatic requests that I've always thought should be implemented. 1) Uniform null. I wish .NET would implement a uniform value for nulls accross the board. Even into the...
1
by: Jon | last post by:
Hola all, I've been pretty excited reading about the object features that are going into the next version of SQL Server. In short, you will be able to natively add objects as User defined types...
14
by: Arne | last post by:
A lot of Firefox users I know, says they have problems with validation where the ampersand sign has to be written as &amp; to be valid. I don't have Firefox my self and don't wont to install it only...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.