CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.microsoft_application_blocks Tags:
Item Type: NewsGroup Date Entered: 11/14/2007 7:40:22 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 12 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
edreyes77
Asp.Net User
SQL Translation11/14/2007 7:40:22 PM

0/0

I was wondering if I have to different connection strings in app.config with one a connection string to oracle and another a connection string to SQL Server.  When i try a embedded SQL statement in my C# and set the CommandText of DbCommand, does EntLib 3.0 have some facility to change the SQL Server query to an Oracle Query or vice-versa?

 

Regards,

ed

Triax
Asp.Net User
Re: SQL Translation11/15/2007 12:43:34 AM

0/0

Uh, no. You have to submit the SQL statement in a dialect that the target database will understand.

That's why I use an O/RM. 


Matthew Noonan

Noonan Consulting Inc.
EasyObjects.NET - The O/RM architecture for the Enterprise Library
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Aspect-oriented Database Systems Authors: Awais Rashid, Pages: 176, Published: 2004
Data Management: Data, Data Everywhere ; 24th British National Conference on Databases, BNCOD 24, Glasgow, UK, July 3-5, 2007 : Proceedings Authors: Richard Cooper, Jessie Kennedy, Pages: 258, Published: 2007
SQL/400 Developer's Guide Authors: Paul Conte, Mike Cravitz, Pages: 508, Published: 2000
Understanding SQL and Java Together: A Guide to SQLJ, JDBC, and Related Technologies Authors: Jim Melton, Andrew Eisenberg, Pages: 514, Published: 2000
Pro LINQ: Language Integrated Query in C# 2008 Authors: Joseph C. Rattz, Joseph C Rattz, Jr, Pages: 600, Published: 2007
Conceptual Modeling - ER '97: 16th International Conference on Conceptual Modeling, Los Angeles, California, USA, November 3-5, 1997 : Proceedings Authors: David W. Embley, Robert C. Goldstein, Pages: 477, Published: 1997
Parallel Database Systems: PRISMA Workshop : Noordwijk, The Netherlands, September 24-26, 1990 : Proceedings Authors: Pierre America, Pages: 433, Published: 1991
Database and XML Technologies: First International XML Database Symposium, XSym 2003, Berlin, Germany, September 8, 2003 : Proceedings Authors: Zohra Bellahsène, Akmal B. Chaudhri, Erhard Rahm, Michael Rys, Rainer Unland, Pages: 281, Published: 2003
Conceptual Modeling for Advanced Application Domains: ER 2004 Workshops, CoMoGIS, CoMWIM, ECDM, CoMoA, DGOV, and ECOMO, Shanghai, China, November 8-12, 2004 : Proceedings Authors: Shan Wang, Pages: 692, Published: 2004

Web:
Jess Robinson / SQL-Translator - search.cpan.org SQL::Translator::Filter::Globals, Add global fields and indices to all tables. ... SQL::Translator::Parser, describes how to write a parser, 1.09 ...
Downloads - JoyJoin - SQL TRANSLATION HELPER 1.01 Shareware Software JoyJoin - SQL TRANSLATION HELPER 1.01. Download. filesize 479.82 KB. This tool translates Oracle SQL statements into non-Oracle RDBMS statements. ...
A Comprehensive XQuery to SQL Translation using Dynamic Interval ... ing SQL queries produced by the translation, there are areas ..... SQL TRANSLATION FOR XQUERY. The translation of XQuery expressions to relational que- ...
SwisSQL Console: SQL Converter/Translator Tool. Software to ... SwisSQL Console SQL Query Translator/Converter tool. Software to convert SQL queries across Oracle, SQL Server, DB2, Informix, Sybase ASE, MySQL, ...
Join minimization in XML-to-SQL translation Join minimization in XML-to-SQL translation: an algebraic approach ... " Efficient XML-to-SQL Query Translation: Where to Add the Intelligence". ...
A Comprehensive XQuery to SQL Translation Using Dynamic Interval ... The WC XQuery language recommendation, based on a hierarchical and ordered document model, supports a wide variety of constructs and use cases.
SQL translation using an attribute grammar SQL translation can be simplified in the target language is well defined. A well -defined target language allows the semantics of SQL to be specified in ...
Microsoft T-SQL to Oracle PL/SQL translation - Stack Overflow Is there are tool or utility available to easily translate T-SQL into PL/SQL, a keyword mapper is the sort of thing I'm looking for. ...
SQLFairy - The SQL Translator SQL::Translator is a group of Perl modules that manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting ...
Spreadsheet to SQL translation - Patent 7299223 Users can create computational models in a spreadsheet application and automatically apply the model to data stored in a relational database.

Videos:
Peppermint - F*** Sql (Primafest 2008) This is the video of song F*** Sql by Peppermint band. From concert Primafest 2008.And sorry, sound isn't very good because I was near the speaker. ...
An Introduction to SQLite Google TechTalks May 31, 2006 Richard Hipp ABSTRACT SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQ...
Web Applications and the Ubiquitous Web Google TechTalks February 1, 2006 Dave Raggett Dave Raggett is currently a W3C Fellow from Canon, and W3C Activity Lead for Multimodal Interaction....
A Googly MySQL Cluster Talk Google TechTalks April 28, 2006 Stewart Smith Stewart Smith works for MySQL AB as a software engineer working on MySQL Cluster. He is an active memb...




Search This Site:










ibuyspy store vs oscommerce

re-building error

meta names ==> removing dotnetnuke info.

usersonline - getonlineuserstatistics stored procedure incorrect statement

prolongin the formsauthentication

not getting the tree control

forms based authentication against a database of users

what is the problem using data explorer to edit table with guid?

very urgent problem : all users have admin access on production portal !!!

help me first module dnn 3.0.12

copying the aspnetdb to remote host site.

how to generate certificate

login control error message : failed to generate a user instance of sql server due to a failure in starting the process for the user instance. the connection will be closed.

login redirection

team system release date?

i have added some more user info fields and am getting an error.

iwam_w03server login error! when installing commerce starter kit.

how about a module with exchange server functionality ...

vs2005 sp1 problems

deleting files from hard disk

windows authentication & network groups

private messages 1.01

references in the vs2005 web application projects

createuserwizard event model?

how to set the publish folder

general what is and can it questions?

map quest

membership & profile provider question

can't move my modules to another page

style sheets and user controls

 
All Times Are GMT