Oracle 10g VS SQL Server 2005

[adshocker]

hi all,

i'm wondering as to which database would be best used when developing an application using VB.NET 2003 as the FrontEnd.

any comments or suggestions will be greatly appreciated.

 

[cjard]

I'd use Oracle no matter what the front end.. It's a much nicer SQL playground

 

[adshocker]

i do agree with you on that... dont get me wrong.. i like oracle better than any other database. but are there any compatibility issues with VB.Net 2003 and Oracle... what i mean is since Microsoft created VB.Net and SQL Server 2005, does that mean they work better together or not necessarily?

 

[cjard]

You get used to the retardedness of the IDE when dealing with Oracle. Integration isnt as good as with MS products, true, but once you know the foibles they are easily avoided.

The biggest advice I could give actually, would be to put any complex query text into a view, and keep the IDE SQLs simple.. SELECT * FROM VIEW WHERE whatever

Additionally, remember that when you use stored procedures, it wont automatically map the parameters of the procedure to datatable columns because the wizard isnt very smart. That's the most tedious part of the development if using a stored procedure, and often I edit the xml directly with a regular expression (all my parameters are named IN_column_name). Normally you open properties, click the parameter, navigate the SourceCOlumn combo and choose the column that is to fill this parameter..

 

[adshocker]

thanks for the advice.. appreciate it.