SharpDevelop Community

Get your problems solved!
Welcome to SharpDevelop Community Sign in | Join | Help
in Search
Home Blogs Forums Photos

Dickon Field

Table Describe and SQL Server Support in SharpServerTools

The SharpServerTools component has moved on a bit:

  • refactored to make each server tool an addin, and enable addins for each database server type
  • support for Oracle and SQLServer
  • both have table describe functionality - right click on a table and invoke 'Describe' opens a browser of the metadata for that table

SharpDbTools with SQLServer and table describe functionality

Published Nov 09 2006, 10:52 PM by dikon

Comments

 

sbosanquet said:

Are there plans on adding support for MySQL or Firebird?

November 15, 2006 6:34 PM
 

dikon said:

My next priority is to complete a query tool with field name completion using the SharpDevelop TextEditorControl integrated into the metadata management service in SharpServerTools - this doesn't look too difficult so it shouldn't take too long once I have understood in a bit more detail how this control works.

I'd very much like to add support for other dbs after that - it would be straightforward to do so if they have an ado.net 2.0 compliant db library which is free. crlabs provide one but it isn't free. MySQL's Connector/Net 5.0 is free, but I am not sure how compliant it is with ado.net 2.0 - I'll have to investigate.

I haven't started to look at Firebird yet. I would have thought MySQL is a priority over Firebird?

Dickon

November 16, 2006 6:15 PM
 

roger.zavala said:

I like Sharpdevelop.  I has used with Postgresql, and i want work in support Postgresql in SharpDevelop equal how work Sql Server.   My english is poor, but maybe to do good work with your help and coordination.

Atentamente

Róger Zavala

www.sigis.com.ve

Note:

I ams experimented Gis Developer.  In the Future, create Gis features for SharpDevelop for MapServer Solutions would can be a good Idea.  

November 29, 2006 3:32 AM
 

dikon said:

Hi Roge

If you'd like to build Postgresql support I'd be very happy to work with you. Send me a private message via the forum and I'll reply with contact details and then I can explain how servertools/dbtools works so far. The problem you may face with postgresql is the lack of full ado.net 2.0 support. This is pretty challenging if you want to provide metadata, transaction enlistment and the many good things that ado.net 2 provides. DbTools relies on ado.net 2.0 support. Anyway, I'm very happy to see where we get to with it

regards

Dickon

Dezember 6, 2006 1:33 AM

This Blog

Syndication
2005-2008 ic#code
Powered by Community Server (Commercial Edition), by Telligent Systems
Don't contact us via this (fleischfalle@alphasierrapapa.com) email address.