Re: [Firebird-net-provider] Checking database existence

[Pierre A. <pie...@op...>]

Hi Jiri,

We have gone the "try to connect to database" route. Trying to create
the database requires that you also cleanup afterwards in order not to
leave an empty database lying around; and what if you can't delete it?
Or what if some other process tries to do the same thing at the same
time?

Obviously, trying to connect to the database might fail, but then, if
it fails, that's as good as no database in my case: I can't access to
the data!

Pierre

-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...] 
Sent: mercredi 5 juin 2013 15:47
To: For users and developers of the Firebird .NET providers
Subject: [Firebird-net-provider] Checking database existence

Hi *,

I was recently rethinking some stuff we do (or not) support for Entity
Framework. One think we don't support is checking database existence
(migrations, initializers, ...). I know the API itself doesn't support
it, but as I checked how other tools and products are solving it it's
basically always just trying to pen the connection. if it fails it
supposes the database does not exists. I also found and idea to try to
create the database (without rewriting). There are, for both, cases
when it can fail and hence returning false even it the database
actually does exist - like not having enough permission (from top of
my head).

What do you think? Do you think it's a good idea to add support like
this? And if so what's better approach. Try to connect or try to
create? Where do you see all the false negatives? Are these
acceptable?

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

----------------------------------------------------------------------------
--
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider