Comparison of a simple select statement in C-omega vs. ADO.Net

re: Comparison of a simple select statement in C-omega vs. ADO.Net

AIM48 — Mon, 21 Mar 2005 02:15:00 GMT

This is great - this is what i was expecting when i first heard of ".net code as stored procedures"

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Paul Wilson — Mon, 21 Mar 2005 02:29:00 GMT

Will this work with any database, or just MS SQL?

Thanks, Paul Wilson

re: Comparison of a simple select statement in C-omega vs. ADO.Net

David M. Kean — Mon, 21 Mar 2005 02:45:00 GMT

What happens if your database structure changes? Where does C Omega get the schema of the database from?

C -Omega looks very

Steve Eichert — Mon, 21 Mar 2005 05:53:00 GMT

C -Omega looks very

C-Omega

wesbran.com — Mon, 21 Mar 2005 05:59:00 GMT

Rick Byers, a developer on the CLR team at Microsoft, has posted an interesting comparison of the select statement in ADO.NET vs Cω. Cω (C-Omega) is an extension to the C# programming language that allows for greater integration between the...

re: Comparison of a simple select statement in C-omega vs. ADO.Net

dru — Mon, 21 Mar 2005 04:12:00 GMT

Damn! This is excellent.

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Rick Byers — Mon, 21 Mar 2005 05:47:00 GMT

Paul, One of the design goals of Cw is to isolate the language from the database implementation. There is certainly nothing baked into the language specific to MS SQL. However, in order to talk to a database, you need to generate a "database assembly". Cw comes with a Sql2COmega tool which does this automatically for MS Sql. I believe the intention is that you could replace that tool with a different one for different databases. However, I have no idea if that would actually work with the current bits - I suspect it has really only been tested with MS SQL, so there may be some interoperability bugs. Regardless, the important thing is that the design is database-neutral. In fact, you can use the same SELECT statement to get data from an XML doc, or even just an in-memory object graph :-)

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Rick Byers — Mon, 21 Mar 2005 05:53:00 GMT

David, Cw gets the database structure from a "database assembly" that is generated either by the Visual Studio integration, or by running a command-line tool. This is similar to the way strongly typed datasets work in ADO.Net today. However, with Cw database assemblies, you should be able to detect most relevant database changes immediately by rebuilding the database assembly and recompiling. There is no interactive "XSD designer" or anything, so rebuilding should be fully automatic. In fact, you'll get excellent error messages point to the parts of the code that no longer conform to the database schema (complete with Intellisense in VS guiding you along).

Of course, if the database changes and we don't rebuild our database assembly, the application will get a typical SqlException or something.

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Rick Byers — Mon, 21 Mar 2005 06:05:00 GMT

Thanks for all the positive comments! I hope this is a sign people will find my talk interesting <grin>. I think this stuff is cool and extremely relevant to the future of mainstream programming, but I wasn't sure how many other people would feel that way. In fact, I'm quite surprised at the lack of buz about this stuff.

At least Anders also thinks this kind of thing is important: http://www.theserverside.net/talks/videos/AndersHejlsberg/dsl/q17.html

.::Szőkelizer 133::.

RIO - Randektív Informatikai Oldal — Mon, 21 Mar 2005 09:47:00 GMT

<p><ul><li><a href="http://metaatem.net/words" target="_blank">Spell with flickr</a></li><li><a href="http://aspalliance.com/articleViewer.aspx?aId=652&pId=1" target="_blank&quo

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Cleve Littlefield — Mon, 21 Mar 2005 08:29:00 GMT

How does this correspond to the work Anders is doing in this area? Are you guys working together or will I expect a different syntax from his implementation?

Sorry to say but for C# I dont put much stake in anything that doesnt have his blessing...

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Sahil Malik — Mon, 21 Mar 2005 14:51:00 GMT

Interesting .... is all I'll say at this point :).

There's so much more under the seams that I'd rather kick the tires off before saying OH MY GOD EXCELLENT IM GOING BONKERS !!

It's "interesting" at this point .. worth watchin' out 4 !!

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Rick Byers — Mon, 21 Mar 2005 15:09:00 GMT

Cleve,
Cw is just a research prototype to experiment with ideas. There is no relationship with C#. The C# team has not announced any details of their plans other than the general comments Anders has made. One thing Anders told me was that, being a research language, the Cw folks had the freedom to experiment and risk screwing up. C# will not have that freedom, so they will have to take a more cautious approach. Also note that I'm not affiliated with either the C# or Cw teams - I just think this is cool, Iwork on the CLR.

Sahil,
That's exactly the right approach. This is a hard problem. I find it interesting to get a glimpse into some approaches that could be followed by mainstream languages, but that is really all Cw is good for. Cw is licensed for academic use only, and is certainly not a production environment.

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Craig Humphrey — Mon, 21 Mar 2005 20:18:00 GMT

Excellent stuff guys, kinda reminds me of what Oracle did with plsql (as an object based library for C about 10 years ago) and IIRC Delphi...

Looking forward to seeing this supported in the main-stream languages, well, C# and perhaps C++ :)

re: Comparison of a simple select statement in C-omega vs. ADO.Net

Gabe — Wed, 23 Mar 2005 03:09:00 GMT

This kind of language feature needs to be fast tracked into the entire .NET platform! "Impedience mismatch" between object oriented languages and relational data is a huge productivity sucker and source of errors. 90% of my business object code consitis of the C.R.U.D. This type of methodology aliviates the most painful aspects. I want this now! :)

I can't emphasize this enough. A language that can work with and query the data natively (and with strong typing) is nothing short of revolutionary. ADO.NET and VFP come close, but this looks like the real deal.

Interesting finds so far this week

Jason Haley — Thu, 24 Mar 2005 02:16:00 GMT

Interesting finds so far this week

Interested in C-omega? LINQ finally announced!

Rick Byers — Wed, 14 Sep 2005 02:04:46 GMT

Ever since I started planning for my users-group talk (and wrote this blog entry) about data access with...

re: Luna 11vs. ADO.Net

tatianna — Wed, 29 Mar 2006 08:30:31 GMT

this is an awsome web site and i would like to know how to find a comparinsion statement thanks tatianna

Comparison of a simple select statement in DLinq (C# 3.0) vs. ADO.Net

Rick Byers — Mon, 27 Oct 2008 21:37:38 GMT

Six months ago I posted a comparison of a simple select statement in C-omega vs. ADO.Net which some people

Interested in C-omega? LINQ finally announced!

Rick Byers — Mon, 27 Oct 2008 21:38:09 GMT

Ever since I started planning for my users-group talk (and wrote this blog entry ) about data access