Sunday, July 30, 2006

Lets have a look how people behind the .Net Framework team thinking in terms of application compatibility when it comes to a move between different Framework versions and how they are dealing with the breaking changes. Here Jason Zander is helping us out while moving from one version to the other. In addition he added a couple of interesting questions that every one would like to know.

If you are having such problems then this post is for you. http://blogs.msdn.com/jasonz/archive/2005/04/25/411925.aspx

Cheers,

7/30/2006 7:27:26 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Saturday, July 29, 2006

For those who would like to learn how .Net Framework 3.0 relates to other versions of .Net Framework, installation, deployment and detection, visit MSDN http://msdn.microsoft.com/winfx/default.aspx?pull=/library/en-us/dnlong/html/netfx30.asp to get details by reading this white paper

7/29/2006 7:59:39 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Friday, July 28, 2006

See Jason Zander in action on Channel9 http://channel9.msdn.com/Showpost.aspx?postid=217428. In this interview Jason provides excellent details about .Net FX 3.0 (aka .Net Framework 3.0), an excellent oppertunity to find your answers right from the source.

7/28/2006 8:05:16 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Wednesday, July 26, 2006

"There is absolutely NO reason to maintain backwards compatibility with previous versions of .NET with new versions.  First you're artificially tying your hands, second, since the frameworks can live side-by-side (except the web.config bug between .net 2.0 and .net 1.1 virtual directories) there is absolutely no reason for for it. (ship the version that your application requires with your application!)"

This post from Somasegar makes some sense http://blogs.msdn.com/somasegar/archive/2006/05/18/601354.aspx

 

7/26/2006 8:13:44 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Saturday, July 22, 2006

What if I fill my DataSet using an XML file rather then Database, sounds interesting...let's have a look

private void Page_Load(object sender, System.EventArgs e)
{
    DataSet dstObject = new DataSet() ;
    dstObject.ReadXml(MapPath("./MyXMLFile.xml")) ;
    Repeater1.DataSource = dstObject ;
    Repeater1.DataBind() ;
}

Easy, ain't it? try and have fun.

Cheers,

 

7/22/2006 6:34:00 AM UTC  #    Disclaimer  |  Comments [4]  | 
 Wednesday, July 19, 2006

Retreiving one time configuration parameters from multiple tables is a norm in todays database based applications and by following this technique reducing the roundtrips to an acceptable level could be achieved.

string conString = "your_connection_string" ;
string sqlString = "Select * from Suppliers; Select * from Vendors" ;
OracleDataAdapter adp = new OracleDataAdapter(sqlString, conString) ;
DataSet dst = new DataSet() ;
adp.Fill(dst) ;

Look at the query variable it contains more then a single table separated by commas, this is a powerful feature through which you could query more then one table in one database call, imagine how you are reducing the roundtrips to a normal level, when your application have thousand of database hits, life become eaier and also fun.

But when you execute this ADO.NET will replace the orignal table names with something like Table1, Table2 and so on, so work accordingly simply use DataAdapter's TableMapping method to change the name back to their orignal names.

adp.TableMapping.Add("Table1", "Suppliers") ;
adp.TableMapping.Add("Table2", "Vendors") ;

Notice we are running through Table1..2 and its because ADO.NET name them by starting from 1 to number of tables requested during DataAdapter call.

Try out and let me know how you feel the difference.

Cheers,

7/19/2006 6:09:17 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Tuesday, July 04, 2006

A nice way of finding difference between tables is the TABLEDIFF command.

Well, TABLEDIFF is primarily replicating tables but we can also utilize in comparing tables.

To get a detailed help on TABLEDIFF, type

C:\Program Files\Microsoft SQL Server\90\COM>TABLEDIFF /?

Keep in mind that in order to see the difference the source and destination tables must be identical.

7/4/2006 5:58:59 PM UTC  #    Disclaimer  |  Comments [0]  | 

This week we are discussing about Flexible Model for Data Integration.

Meet us in Grano Coffee Shop on 5th July, between 1800 hrs - 1900 hrs

Meeting slides will be made available on Resource section. http://www.yukonizer.com/nnd403/Resources/tabid/59/Default.aspx

Next meeting will be announced soon on Events section on group website.

Thanks.

7/4/2006 4:17:40 PM UTC  #    Disclaimer  |  Comments [1]  |