473,327 Members | 1,919 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,327 software developers and data experts.

LINQ

Hello NG,

we are currently beginning to port our Software from
VB6 to .NET. At the moment I am looking for an object
oriented way to do data-access. LINQ to SQL came in
my mind as a very good approach. As Orcas is still
available only as a preview we want to write our new
code for the .NET Framework 2.0. The problem is,
there is no LINQ support so we would have to do another
port at the time Orcas is released.

What i am looking for, is an intermediate approach. Like
implementing a small subset of the DLINQ interface on the .NET 2.0
Platform for switching to .NET 3.5 with as less effort as
possible. We already have built a Framework for dynamically
generating SQL Queries for different databases with convenience, so this
would be easy at least for simple CRUD operations.

Does anybody know if there is a simple way to parse LINQ
queries so we could now do something like :

Query<Customer= QueryParserWhateverNameYouHave.Parse<Customer>("fr om c
in customers select c")

and later on just skip to

var q = from c in customers select c

via text replace ?? I know we could create a parser with tools
like ANTLR.

Or do you have any other idea on how to solve the problem ? Any ideas ?
Perhaps you can provide a better way or do think that this intermediate
step is crap. Arguments ?

Thanks in advance,
Philipp


Jul 9 '07 #1
1 1693
Free or for a price?

For a price, you can pick up Genome. While not precisely LINQ they use a
query language (OQL) that will make it easier to move to LINQ.

NOTE: There should be a go live for VS 2008 (Orcas) by fall. It is your
decision whether or not to release on a supported beta or not, of course.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************************************************
Think outside the box!
************************************************
"Philipp Brune" <he****@gmx.dewrote in message
news:eT**************@TK2MSFTNGP06.phx.gbl...
Hello NG,

we are currently beginning to port our Software from
VB6 to .NET. At the moment I am looking for an object
oriented way to do data-access. LINQ to SQL came in
my mind as a very good approach. As Orcas is still
available only as a preview we want to write our new
code for the .NET Framework 2.0. The problem is,
there is no LINQ support so we would have to do another
port at the time Orcas is released.

What i am looking for, is an intermediate approach. Like
implementing a small subset of the DLINQ interface on the .NET 2.0
Platform for switching to .NET 3.5 with as less effort as
possible. We already have built a Framework for dynamically
generating SQL Queries for different databases with convenience, so this
would be easy at least for simple CRUD operations.

Does anybody know if there is a simple way to parse LINQ
queries so we could now do something like :

Query<Customer= QueryParserWhateverNameYouHave.Parse<Customer>("fr om c
in customers select c")

and later on just skip to

var q = from c in customers select c

via text replace ?? I know we could create a parser with tools
like ANTLR.

Or do you have any other idea on how to solve the problem ? Any ideas ?
Perhaps you can provide a better way or do think that this intermediate
step is crap. Arguments ?

Thanks in advance,
Philipp


Jul 10 '07 #2

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

Similar topics

4
by: Dave Johnson | last post by:
Greetings, i want to be able to use linq new technology with sql server. the senario i am not able to do so far is as follow: 1- i program with linq 2- be able to generate and manipulate...
4
by: cj | last post by:
Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've seen demos of it with SQL Server but they've used it with a server browser and I don't think that'd work when I need to see VFP...
9
by: =?Utf-8?B?cmF1bGF2aQ==?= | last post by:
Hi all: after reading different places/sites about linq... I ran into these questions: 1. What framework do we need to run linq ? (does it depend on what version of visual studio we have?) how...
0
by: =?Utf-8?B?SHlwZXJjb2Rlcg==?= | last post by:
I'm encountering some strange behavior after deploying a ASP.net 3.5 website to production, i'm unable to reproduce these in my dev environment. This error seems to occur very randomly but it's...
4
by: =?Utf-8?B?RXJpYyBGYWxza2Vu?= | last post by:
We’re storing our main entity in an insert only table which stores the history of past revisions, but we’re facing problems with storing this history as LINQ will only update the entity, and...
14
by: thj | last post by:
Hi, I was wondering what you guys are using and why? LINQ to SQL or NHibernate? Thanks in advance, Tommy
9
by: Cirene | last post by:
I'm about to begin a brand new, big, ASP.NET project (using 3.5 .net fw), VS 2008. I'm using MySQL as the backend (customer request.) I have absolutely no experience with LINQ and/or the Entity...
3
by: =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post by:
I'm attempting to use LINQ to insert a record into a child table and I'm receiving a "Specified cast is not valid" error that has something to do w/ the keys involved. The stack trace is: ...
4
by: George | last post by:
I am a bit conservative type and usually give some time for technology to mature before starting to try it. Today my question is Linq. To start using it or not. So here is the voting questions....
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.