Re: [Firebird-net-provider] [firebird-support] Clarify / Document Install Procedure

[Clyde Eisenbeis]

I finally remembered the additional step ... described in StackOverflow:

//---
//To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. -- then Tools -> Library Package Manager -> Manage NuGet
//Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).
//
//Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
//add using FirebirdSql.Data.FirebirdClient;
//---
//stackoverflow.com/questions/42864674/how-do-i-create-a-firebird-database-file-programmatically
//
//From www.firebirdsql.org/en/firebird-3-0/ ... downloaded
Firebird-3.0.2.32703-0_x64.zip
//
//Unzipped into temporary subdir (Unzip)
//
//Created fb3embedded subdir in project subdir ... next to bin, obj, etc.
//
//Move from Unzip subdir to fb3embedded subdir
//intl folder and all contents
//plugins\engine12.dll
//fbclient.dll
//firebird.msg
//icu*
//msvcp100.dll
//msvcr100.dll
//
// add to the code public const string stCLIENT_LIBRARY =
@"..\..\fb3embedded\fbclient.dll";
//-------

On Thu, Apr 6, 2017 at 8:36 AM, Clyde Eisenbeis <cte...@gmail.com> wrote:
> After most things work, I decided to start with a new program /
> project ... over time, the memory fades.
>
> Here is the procedure I used:
>
> To install Firebird: Visual Studio 2013 -> File -> New -> Project,
> etc. -- then Tools -> Library Package Manager -> Manage NuGet
> Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
> Install (button).
>
> Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>
> Then added "using FirebirdSql.Data.FirebirdClient".
>
> This statement results in a compile error:
>
> string stCreateConnectionString = new FbConnectionStringBuilder {
> Database = stPathFilename,
> UserID = stUserID,
> Password = stPassword,
> ServerType = FbServerType.Embedded,
> ClientLibrary = stCLIENT_LIBRARY
> }.ToString();
>
> Does not like "stCLIENT_LIBRARY".  What step am I missing?  Thanks!

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [firebird-support] Clarify / Document Install Procedure

[Clyde Eisenbeis]

After most things work, I decided to start with a new program /
project ... over time, the memory fades.

Here is the procedure I used:

To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. -- then Tools -> Library Package Manager -> Manage NuGet
Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).

Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.

Then added "using FirebirdSql.Data.FirebirdClient".

This statement results in a compile error:

string stCreateConnectionString = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = FbServerType.Embedded,
ClientLibrary = stCLIENT_LIBRARY
}.ToString();

Does not like "stCLIENT_LIBRARY".  What step am I missing?  Thanks!

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird-support] Create Autoincrement

[Clyde Eisenbeis]

I should have started this email with ... C# ... Firebird ADO.NET ...
FirebirdClient.5.8.0 ... Visual Studio 2013.

I tried entering

CREATE GENERATOR gen_t1_id;
SET GENERATOR gen_t1_id TO 0;

set term !! ;
CREATE TRIGGER T1_BI FOR T1

in my C# code ... the compiler complains.  This appears to not be
relevant for C#.

What I need is the ability to add data and retrieve the primary key
which needs to be autoincremented ... see
http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable
for the current code.

On Fri, Mar 24, 2017 at 10:57 AM, Scott Morgan <bl...@blueyonder.co.uk> wrote:
> On 03/24/2017 03:09 PM, Clyde Eisenbeis wrote:
>> Using http://www.firebirdfaq.org/faq29/ as a reference.
>>
>> 1) If I understand this website, the CREATE GENERATOR is initiated only once?
>
> Yes. It's a global item like a table, so you just need to create it once
> (and commit that change to the DB,. Changes to tables and other global
> items like that all need to be committed before using them). It'll have
> an initial value of 0 and calls to GEN_ID will increment it by the
> specified value (usually 1)
>
>> 2) Likewise the CREATE TRIGGER is initiated only once?
>
> Yes. It's just associated with the table, ready to run whenever the
> specific event happens, so...
>
>> 3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)?
>
> The "ACTIVE BEFORE INSERT POSITION 0" specifies that. In this case
> 'BEFORE INSERT', so whenever a new item is inserted into the table, that
> trigger is run.
>
>> 4) I see the 'id' field in table t1.  I see upper case 'ID' in the
>> TRIGGER.  Are these two the same?
>
> Yes. (Bit of bad form in that FAQ there I'd say, mixing case) Unquoted
> identifiers (names of tables, columns, etc.) are stored in upper case.
> So id, ID, iD, and Id are all the same (ID).
>
>
> You'll get more detailed answers about this stuff on the main Firebird
> mailing list, and I highly recommend the Firebird Book by Helen Borrie,
> which covers all this clearly and in depth. It's things like triggers
> and foreign keys that make a proper DB so powerful, but it can take a
> bit of getting used to.
>
> Scott
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [firebird-support] Create Autoincrement

[Clyde Eisenbeis]

Using http://www.firebirdfaq.org/faq29/ as a reference.

1) If I understand this website, the CREATE GENERATOR is initiated only once?

2) Likewise the CREATE TRIGGER is initiated only once?

3) When is the T1_BI used (CREATE TRIGGER T1_BI FOR T1)?

4) I see the 'id' field in table t1.  I see upper case 'ID' in the
TRIGGER.  Are these two the same?

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde Eisenbeis]

1) The filename was zzFirebirdTest.fdb.  The end result is
ZZFIREBIRDTEST.FDB.

Here is solution converting the UPPERCASE back to the original:

string stPATHFILENAME = stPathFilename.ToUpper();
System.IO.File.Move(@stPATHFILENAME, @stPathFilename);

On Sun, Mar 19, 2017 at 6:07 AM, Mark Rotteveel  wrote:
> On 19-3-2017 11:56, Jiří Činčura wrote:
>>> Firebird Embedded on windows does not check for username and password,
>>> so you can leave them out. For a normal Firebird server, username is
>>> case insensitive, but password - of course - is case sensitive.
>>
>> But the grants are still followed. So username/role is important,
>> password not much.
>>
>
> You are right, forgot about that :)
>
> --
> Mark Rotteveel
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Create Database Tables

[Clyde Eisenbeis]

1) I think it would be

string stOpenConn = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = FbServerType.Embedded,
ClientLibrary = stCLIENT_LIBRARY
}.ToString();
using (FbConnection fbConn = new FbConnection(stOpenConn)) {
try {
fbConn.Open();

On Thu, Mar 23, 2017 at 8:30 AM, Clyde Eisenbeis <cte...@gmail.com> wrote:
> 1) It's not obvious to me where to put the 'using' with 'try'.  Could
> you provide an example using the code in my first email?
>
> 2) Is this what you recommend?
>
> where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
> fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
> KEY )".
>
> What do I use for 'x'?  This should be variable.
>
> 3)  BLOB SUB_TYPE TEXT is non-Unicode.  The field 'fstInfo' needs to
> handle German.
>
> On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <j...@cincura.net> wrote:
>>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>>> followed by one fbTransaction.Commit()?
>>
>> Yes. Also use `using` block for disposable resource.
>>
>>> 2) I want to be able to handle German vowels, such as umlauts, for
>>> fstInfo.  I don't think VARCHAR is the correct choice as it is
>>> non-unicode.
>>
>> You can use CHARACTER SET clause. Best is probably to use UTF8.
>>
>>> 3) I also want variable lengths, without a max, for fstInfo.  What do
>>> I use in place of the "100"?
>>
>> Then you have to use BLOB SUB_TYPE TEXT.
>>
>> --
>> Mgr. Jiří Činčura
>> https://www.tabsoverspaces.com/
>>
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Create Database Tables

[Clyde Eisenbeis]

1) It's not obvious to me where to put the 'using' with 'try'.  Could
you provide an example using the code in my first email?

2) Is this what you recommend?

where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
KEY )".

What do I use for 'x'?  This should be variable.

3)  BLOB SUB_TYPE TEXT is non-Unicode.  The field 'fstInfo' needs to
handle German.

On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura  wrote:
>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>> followed by one fbTransaction.Commit()?
>
> Yes. Also use `using` block for disposable resource.
>
>> 2) I want to be able to handle German vowels, such as umlauts, for
>> fstInfo.  I don't think VARCHAR is the correct choice as it is
>> non-unicode.
>
> You can use CHARACTER SET clause. Best is probably to use UTF8.
>
>> 3) I also want variable lengths, without a max, for fstInfo.  What do
>> I use in place of the "100"?
>
> Then you have to use BLOB SUB_TYPE TEXT.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Create Database Tables

[Clyde Eisenbeis]

To create a table:
-
int iTablesCount = liststTableNames.Count();
try {
string stOpenConn = new FbConnectionStringBuilder {
Database = stPathFilename,
UserID = stUserID,
Password = stPassword,
ServerType = FbServerType.Embedded,
ClientLibrary = stCLIENT_LIBRARY
}.ToString();
FbConnection fbConn = new FbConnection(stOpenConn);
fbConn.Open();

FbTransaction fbTransaction = fbConn.BeginTransaction();
for (int ii = 0; ii < iTablesCount; ii++) {
string stSql = "CREATE TABLE " + liststTableNames[ii] + "(
" + liststFieldDefinitions[ii] + ")";
FbCommand fbCmd = new FbCommand(stSql, fbConn, fbTransaction);
fbCmd.ExecuteNonQuery();
}
fbTransaction.Commit();
-
where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
fstInfo VARCHAR(100), fiKeyID INTEGER PRIMARY KEY )".

1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
followed by one fbTransaction.Commit()?

2) I want to be able to handle German vowels, such as umlauts, for
fstInfo.  I don't think VARCHAR is the correct choice as it is
non-unicode.

3) I also want variable lengths, without a max, for fstInfo.  What do
I use in place of the "100"?

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde Eisenbeis]

Mark,

I'm not sure how to reply via StackOverflow, so I'll email.

Thanks!  Your description creates an .fdb file. (I think .fdb is the
correct format acronym).

1) The filename was zzFirebirdTest.fdb.  The end result is
ZZFIREBIRDTEST.FDB.  How do I keep TitleCase for the name?

2) UserID = "SYSDBA", Password = "masterkey".  I presume there is no
risk in using anything I want.  Are they case sensitive?

3) Is the pageSize = 4096, a good common practice?

4) I'm struggling to find details about FbConnection.CreateDatabase on
the Firebird Document site.

Apparently the order is ... connection details (string), page size
(int), force writes (bool), overwrite (bool).

The connection string has reserved words, Database, ServerType, etc.

Is there a site that clarifies all of the reserved words / options /
defaults?  I'd like to document this info while it is still fresh in
my mind ... for future projects.


On Sat, Mar 18, 2017 at 4:07 AM, Mark Rotteveel  wrote:
> On 17-3-2017 20:38, Mark Rotteveel wrote:
>> As I said on stack overflow, I'll try to post a more complete answer
>> later this weekend. Also check the other answer posted recently, the
>> links in that mail handle some older versions, but should still apply in
>> general.
>
> I have posted on answer on Stack Overflow:
> http://stackoverflow.com/a/42872385/466862
>
> I hope it helps.
>
> Mark
> --
> Mark Rotteveel
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde Eisenbeis]

I clearly misunderstood.

To be certain I understand the terminology, an embedded server is one
that is accessible via the Internet?

I do want this database to eventually be accessible via the Internet.

I know which tables I want ... and which fields I want in each table.

By dependencies, does that mean table names, field names, passwords, sizes?

How do I create, or download, the Firebird embedded server?

How do I create this database?

On Fri, Mar 17, 2017 at 1:51 PM, Mark Rotteveel <m...@lawinegevaar.nl> wrote:
> On 2017-03-17 17:26, Clyde Eisenbeis wrote:
>> I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in
>> my Debug subdir.
>>
>> The exception is "Unable to find an entry point named
>> 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".
>
> You are missing a crucial point, the Firebird ADO.net provider is not
> like Sqlite, it is **not** a Firebird server, it is only a client to
> connect to a Firebird server, by default through a pure C#
> implementation, alternatively using the native client or to an embedded
> server.
>
> The first option has no dependencies, but the second and third option
> have native dependencies that you need to provide yourself (it is not
> part of the FirebirdSql.Data.FirebirdClient).

> For native you need
> fbclient.dll, for Firebird embedded you need Firebird embedded: for
> Firebird 2.5 and earlier: fbembed.dll and dependencies, for Firebird 3
> fbclient.dll + engine12.dll and dependencies.
>
> If you want to use Firebird embedded, you need to put it in the same
> folder as your application (or at least on the search path).
>
>> On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura <j...@cincura.net> wrote:
>>> If you are not using the server, then location of your embedded
>>> Firebird
>>> library.
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde Eisenbeis]

I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in
my Debug subdir.

The exception is "Unable to find an entry point named
'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".

On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura <j...@cincura.net> wrote:
> If you are not using the server, then location of your embedded Firebird
> library.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> On Thu, Mar 16, 2017, at 16:04, Clyde Eisenbeis wrote:
>> t) I've tried FbConnection.CreateDatabase ... using info from
>> StackOverflow:
>>
>> int pageSize = 4096;
>> bool forcedWrites = true;
>> bool overwrite = false;
>> var connectionString = new FbConnectionStringBuilder
>> {
>> Database = stPathFilename,
>> ServerType = FbServerType.Embedded,
>> UserID = "SYSDBA",
>> Password = "masterkey",
>> ClientLibrary = "fbclient.dll"
>> }.ToString();
>> FbConnection.CreateDatabase(connectionString, pageSize,
>> forcedWrites, overwrite);
>>
>> I had presumed this is standard, except for the stPathFilename.
>>
>> However, this code throughs an exception ... complains about
>> fbclient.dll.  I'm not sure what to use for Client Library.
>>
>> On Wed, Mar 15, 2017 at 1:54 PM, Jiří Činčura <j...@cincura.net> wrote:
>> >> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>> >
>> > To be precise, it's provider, not Firebird.
>> >
>> >> 1) Was the the correct procedure?
>> >
>> > Yes.
>> >
>> >> 2) How do I create a Firebird database file? ... as I did with SQLite
>> >> ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
>> >> where the filename ends with .sqlite.
>> >
>> > FbConnection.CreateDatabase.
>> >
>> > --
>> > Mgr. Jiří Činčura
>> > https://www.tabsoverspaces.com/
>> >
>> >
>> > --
>> > Check out the vibrant tech community on one of the world's most
>> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> > ___
>> > Firebird-net-provider mailing list
>> > Firebird-net-provider@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde Eisenbeis]

t) I've tried FbConnection.CreateDatabase ... using info from StackOverflow:

int pageSize = 4096;
bool forcedWrites = true;
bool overwrite = false;
var connectionString = new FbConnectionStringBuilder
{
Database = stPathFilename,
ServerType = FbServerType.Embedded,
UserID = "SYSDBA",
Password = "masterkey",
ClientLibrary = "fbclient.dll"
}.ToString();
FbConnection.CreateDatabase(connectionString, pageSize,
forcedWrites, overwrite);

I had presumed this is standard, except for the stPathFilename.

However, this code throughs an exception ... complains about
fbclient.dll.  I'm not sure what to use for Client Library.

On Wed, Mar 15, 2017 at 1:54 PM, Jiří Činčura  wrote:
>> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>
> To be precise, it's provider, not Firebird.
>
>> 1) Was the the correct procedure?
>
> Yes.
>
>> 2) How do I create a Firebird database file? ... as I did with SQLite
>> ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
>> where the filename ends with .sqlite.
>
> FbConnection.CreateDatabase.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde Eisenbeis]

I've recently written code using SQLite (C# .NET, System.Data.SQLite)
... decided to try Firebird.

To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. -- then Tools -> Library Package Manager -> Manage NuGet
Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).

Resulted in a) References -> FirebirdSql.Data.FirebirdClient, and b)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.

1) Was the the correct procedure?

2) How do I create a Firebird database file? ... as I did with SQLite
... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
where the filename ends with .sqlite.

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider