1

Topic: linq2db And firebird are on friendly terms?

Somebody uses in the real project linq2db for firebird?
Like all on small but  but:
- Connection with a DB does not rise if port distinct from 3050, the port instructions in a line of a connection as localhost/3250 do not work, other places of a config for the job of port did not find
- Did not see in dock what versions firebird are supported, I use while fb2.0.6
- It is necessary to work with already existing, average on the size, basis - I do not want hands all POCO's classes to write
The task:
To creep in development of the project from a sheaf delphi6, fibplus, firebird on c#.Net, winforms + web, orm I (select), firebird (I do not want to pass to others, it is pleasant firebird (it is convenient, arranges on a functional)
Who can at once checked alternatives orm prompts? (Further on queue check daper)

2

Re: linq2db And firebird are on friendly terms?

LelikBolek wrote:

orm I (select)

Select Entity Framework
https://habrahabr.ru/post/278405/

3

Re: linq2db And firebird are on friendly terms?

LelikBolek;
linq2db Quite to itself works with firebird, including 3.0.
Here, for example, normal to itself an operating config:

<? xml version = "1.0" encoding = "utf-8"?>
<configuration>
<configSections>
<section name = "linq2db" type = "LinqToDB.Configuration. LinqToDBSection, linq2db" requirePermission = "false"/>
</configSections>
<linq2db defaultConfiguration = "One"/>
<connectionStrings>
<add name = "One"
providerName = "Firebird"
connectionString = "User=SYSDBA;Password=masterkey;Database=d: \DATA\mydatabase.fdb;DataSource=localhost;Port=3050;Charset=UTF8;"/>
<add name = "Two"
providerName = "Firebird"
connectionString = "User=SYSDBA;Password=masterkey;Database=d: \DATA\myotherdatabase.fdb;DataSource=localhost;Port=3051;Charset=UTF8;"/>
</connectionStrings>
</configuration>

Generation of classes on an available DB is present through templates T4.
And generally on the questions connected with linq2db it is better on RSDN to go, there regularly appears IT and other developers.

4

Re: linq2db And firebird are on friendly terms?

romangr, port it was possible to consider, thanks
But generation of classes falls,

Severity Code Description Project File Line Suppression State
Error Running transformation: FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code =-206
Column unknown
PP.RDB$NULL_FLAG
At line 15, column 37

That can what nuances of version FB are not considered, in dock and did not find on restrictions of versions. It is a pity certainly
I will try still their predecessor BLToolkit though in new development with the tool which does not develop any more as that unpleasantly to go

5

Re: linq2db And firebird are on friendly terms?

LelikBolek wrote:

Column unknown
PP.RDB$NULL_FLAG
At line15, column37

If not you wrote this request, all questions - to support.NET the provider.

6

Re: linq2db And firebird are on friendly terms?

LelikBolek;
Most likely the version of the provider does not correspond to version . Throw out already  2.0, pass on 2.5.

7

Re: linq2db And firebird are on friendly terms?

LelikBolek;
For  except  I in this bog  would not climb. The MSEC is not on friendly terms with "strangers", want EF - or MSSQL Or Orakl