This isn't question of MS SQL vs. Firebird. For same views, both behave same.
MS add views into model by default.
--
Start uncovering the many advantages of virtual appliances
and start using them to simplify
I'm still not convinced. Sure you can ensure the field is de-facto PK,
but as it's more walking on thin ice than robust design I think you,
as developer, should modify your model accordingly and keep it.
The biggest problem is views. You said that you don't include views into
model because
Might be worth reading
http://blog.cincura.net/231978-seamless-support-for-boolean-and-guid-datatypes-in-firebird-and-entity-framework/
before release; also in case you're not monitoring resolved bugs in
tracker regularly.
I'ts very very nice, but we can't check it right now. Because of
Hi, Jiri.
I have database with views, but i can't import them into model. Did you
try to import views?
--
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and
http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/
Thanks.
But why don't you want to make all columns as keys?
Another question. We have bit fields in MSSQL, which translated to
boolean properties in the model. Is there some possibility to make the
same in FB until #BOOL#
Me? Why me?
I mean by default, as provider developer, during model importing :)
Edit SSDL and use smallint_bool as datatype.
I should do this once or each time after i update model from database?
--
Sell apps to
Have same problems, but only on .NET 4
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
1) any column of table or view field (including not primary keys) with
#PK_GEN# is a key field with autoincrement
Though it's possible, why would you wanna mark field as PK if it's not
in database? This may (and will, you bet) strange errors.
For views, for very small tables without primari
Why are you creating new? Why not pass complete object?
Because i want to work with it in other context and don't want to make
attaching/detaching.
But it's other question.
Can you tell something about this error? Or this error not depends from
FB provider and i should ask help in
Hi Jiri.
Is it hard to implement handling of descriptions like #KEY# and
#REFERENCES#table_or_view(column1, ... , columnN)# for view columns?
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for
It depends on what you define by hard.
Hard - it's when using of existing model generation mechanism is not
possible.
Not hard - it's when it is possible to make small changes in the code to
tell model generator that:
1) any column of table or view field (including not primary keys) with
Hi!
I'm trying to play with EF 4.0 and Firebird .NET Provider and have such
problem which i can't solve.
A have an entity object (Manufacturer) materialized by some
ObjectContext. I need to edit this object. For editor i'm creating new
ObjectContext, pass EntityKey of my manufacturer and
I'm playing with .NET 4 and FB privider and sometimes i've got an error:
Object reference not set to an instance of an object.
at
FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction()
at FirebirdSql.Data.FirebirdClient.FbCommand.Release()
at
Thanks for your work!
--
Download Intelreg; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel
Solved.
The problem is that VS2010 use 32-bit Framework, but compiled program
use 64-bit version.
I copied section DbProviderFactories of machine.config from 32-bit
version to machine.config for 64-bit version and now all working fine.
I've installed VS 2010 Beta 2 and Firebird .NET Provider 2.5.1 + DDEX
2.0.4, but i can't create connection to FB server:
1) From server explorer. I chooose Add connection ... - Data source:
other - Data provider - .NET Framework Data Provider for Firebird.
After this Add connection window
If i remember well that happens when the provider is not properly
registered in the machine.config file.
That's it :-) Thanks!!!
--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of
Hi. I've tried VS 2010 Beta 2 - very nice emotions. There are many
useful features in EF 4.0, such aa lazy loading, cascade deleting,
foreign keys and many other.
I palan to start new project, but i don't like MS SQL. Is it possible to
use FbClient 2.5 with new version of .NET Framework, or i
And it will support new EF 4.0 features?
--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
___
As all you mentioned all EF related not provider, then yes.
But i don't know does new EW requir new features from provider or not :-(
--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
Maybe it's not correct question... Does all new EF 4.0 features will
work with FbClient 2.5 ?
--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
Yes.
Excellent! I'll try it...
--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
___
Firebird-net-provider
Hi.
I've got such error when tried to create ObjectContext (generated by EDM
disigner from FB database):
Failed to find or load the registered .Net Framework Data Provider.
Stack trace:
at System.Data.Common.DbProviderFactories.GetFactory(DataRow
providerRow)
at
You don't have the FirebirdClient assembly in GAC nor in your application's
dir.
It's in GAC, but when i set CopyLocal = true, than other error occured:
FirebirdSql.Data.FirebirdClient, Version=2.5.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c
But i have 2.5.1.0 installed...
Found the problem. Incorrect version of FirebirdClient were specified in
DbProviderFactories section of 64-bit machine config.
So EDM designer worked (think it use 32-bit version of .NET), but
program not...
--
Come
I think, that the server can do nothing with it. And I do not like
autoincrement columns. Generators/Sequences are much more powerfull.
Only some flag to see the column is generated from generator. But I
have doubts engine will support this.
Why autoincrement fields can't be created with help
as there's no way in FB to know that the PK column is autogenerated
using generator (at least I don't), you have to tweak the model to set
this up. Unfortunately every update of model will remove this. I'm
thinking about some special mark (anywhere) in comment to let me know
to mark this as
Thanks!
Try to play with it on new project :)
--
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers brand creativity professionals. Meet
the minds behind Google
Try to play with it on new project :)
I'll try - sorry :)
--
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers brand creativity professionals. Meet
the minds
But the result depends how the columns look like.
I have 2 views:
CREATE TABLE Parents (
IdINTEGER NOT NULL,
Name VARCHAR(100) NOT NULL
);
CREATE VIEW ParentsView(Id, Name) AS
SELECT * FROM Parents;
CREATE TABLE Children (
IdINTEGER NOT NULL,
ParentId
Views in FB doesn't contain PK,
Same in MS SQL
so it's in model, but commented out.
Why?
--
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers
Hi!
I've tested this for working with entities - there are tonns of problems
while updating model from database :-(
1) Primary keys not recognized
2) Relations not recognized
Than i've tried to import real database and had an empty diagram as a
result of importing...
I even don't know what
Checked on 2.5. With keys all fine. But the next problem with views.
1) If i'm importing model from database with views than empty model
generated
2) If i'm importing only tables on first step, than all fine. But if i
want to import views on second step than nothing happens. Views
inporting
Hi, Jiri.
I'm trying to use provider 2.5 in ASP.NET application with FireBird 2.1
and sometimes this application hangs (i've got connection timeouts after
that).
Few years ago we had similar problem with connection pool and made patch
and sent it to Carlos. Carlos applied it into 1.7.1 or 2.0
http://tracker.firebirdsql.org/browse/DNET-156 ???
Yes, seems it is same problem...
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
OK, and what's wrong with this?
Each name should have some sense. What sense in digit 2.0?
Also i have other question. When i installed FirebirdClient 2.5
installer told me that i must uninstall my FirebirdClient 2.1 first. But
what if i want to have both versions? Is it possible to install
Today i tried to connect to stopped server (FB 2.1 RC1) and got en error:
FirebirdSql.Data.FirebirdClient.FbException: No message for error code
335544721 found.
-
This SF.net email is sponsored by: Microsoft
Defy all
This versions has the initial implementation of the Firebird
protocol v11 that comes with Firebird 2.1
What means initial implementation? Does it work with v11 protocol and
what should we do for using it?
-
This SF.net
For me it is very usefull behavior. I think Microsoft's behavior much
more bad.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No
2.
FirebirdSql.Data.Client.Embedded - FirebirdSql.Data.Client.Native
Thought about this. Can i understand that native related to .NET
provider, i.e. implemented inside of provider?
If so, than here is ambiguity and this is bad namespace and i propose
something like
What is version 10 ? Maby Version_1, Version_2, ets... ?
It's the version of FB Protocol. AFAIK.
It's impossible. Newest Interbase server has version 8 and protocol
didn't change in each version, so protocol version can't be greater than
server version. So i think that version 10 sounds
Not ODS, but GDS (the protocol version wasn't the right term).
Ok, than what GDS has FB 1.0 and FB 1.5 ?
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
No, that is one byte that is being communicated while establishing the
connection. IB 5.x had wire protocol version 9, IB 6.x, FB 1.x, FB 2.0,
IB 7.x (and very likely IB 2007) have protocol version 10. FB 2.1
supports protocol versions 10 and 11.
Client talking wire protocol 10 is not
FirebirdSql.Data.Client.Gds - FirebirdSql.Data.Client.Managed10
or
FirebirdSql.Data.Client.Gds - FirebirdSql.Data.Client.Managed.Version10
What is version 10 ? Maby Version_1, Version_2, ets... ?
FirebirdSql.Data.Client.Embedded - FirebirdSql.Data.Client.Native
+1
Carlsos. What about if I review current code for checking buffer length too?
Please don't, i want to release the rc of the 2.1 Not for v2.1
Maybe you are right. Provider 2.1 is in pre-RC state and will be bad if
refactoring cause new problems.
But i want to say that:
1) Buffer length not
For 2.1 more than probably we will need a new GDS implementation, that
will depend on the changes on the remote protocol, i need to check what
are have been done in the server.
New GDS implementation is other question.
Vlad told me that new protocol should be 100% compartiable with old
application (same as i sent to you) still hangs with your fixes :-(
So, what will we do with this? If you have no idea than i can ask advice
from Yemanov or Horsun about this problem.
-
Take Surveys. Earn Cash. Influence
Yes, on the XdrStream class.
http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Client/Gds/XdrStream.cs?r1=28r2=102
Make same changes in
NETProvider_17\source\FirebirdSql.Data.Gds\XdrStream.cs and my old test
application (same as i
Or how to fix this issue?
Use database aliases instead of path.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business
Hi!
I'm about bug http://tracker.firebirdsql.org/browse/DNET-85
Tracker was not working long time so i could not write any answer later.
And i wrote you a letter a few days ago on carlosga05 at gmail. Seems
you have not got it :-/
So i have a question. You wrote
i'm not sure the fix is
Hi all!
Sorry for offtopic but i need your help.
The situation is next. As you know in VS 2005 form inheritance was
broken for strip controls (menuee, toolstrips, binding navigator, ets)
and grid view. And this is very annoying bug which cause me to change
IDE back on Delphi 7 for winforms
You are right, this is off topic really, and probably best not discussed
in here anyway, there may be a better group for us to discuss this in.
But this is single international newsgroup which i use, so i hope people
from here can help...
Personally, I'm looking forward to the Highlander
Changes are in SVN now.
Greate, thanks!
Excuse me, but did you try my test with hanging, because it seems you
forgot? :-)
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and
If it can help, provider's stack trace is next:
at System.Net.OSSOCK.recv(IntPtr, IntPtr, Int32, SocketFlags)
at System.Net.Sockets.Socket.Receive(Byte[], Int32, Int32, SocketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[], Int32, Int32)
at System.IO.BufferedStream.Read(Byte[], Int32,
I will try to debug it today, but i think it's haning on reading the
server response to the command execution, what can mean
that the server was expecting more data to be sent from the provider.
Thanks!!!
I've tested this problem in different ways and found yet one strange
behavior. To
I can't reproduce the error! Tested with FB1.5.4 and 2.0.1 and works!
Have you tested using my test application + data from war1.xml?
I think problem is not in server, because it works with ServerType=1.
Also it hangs only in some special kind of data (i wrote such data in
war1.xml).
PS I
I can't do the test right now, but can you try to define
the description parameter to have UNICODE_FSS character set and run the
test ??
No, i can't because i need to insert ~28000 characters into varchar
field and FB does not allow to define such long fields in UNICODE_FSS.
I tried to
I tried to define maximal allowed characters count:
EXECUTE BLOCK (Description VARCHAR(10921) CHARACTER SET UNICODE_FSS
= @Description) AS BEGIN END;
and i've got an error: arithmetic exception, numeric overflow, or
string truncation
Ive thought about this - this is strange behavior.
It's because unicode doesn't store all chars in 2 or 3 or more bytes.
Only national chars are stored on more bytes. Standard US-ASCII (and
some others) are store on 1 byte to keep backward compatibility.
I wrote the same. And, if you look at text, ~99% of character there are
digits, english
I haven't read the whole thread, but shouldn't be better to use blob for
storing this long texts? Sooner or later (everybody known Murphy ;))
this will not be enough.
No, because of performance issues. Few weeks ago i discussed this
problem with Vlad Horsun. There are very big performance
Hi!
Only now i see that it is impossible to connect to FB2 database with
UTF8, KOI8-R or KOI8-U charsets. And i looked at FirebirdSql.Data.Common
and saw that there are no support for KOI8-R and KOI8-U :-(
P.S. Maybe it will be nice to have a new parameter in connection string,
something
What tool did you use there?
I used dotTrace from http://www.jetbrains.com/
There are another one very powerful tool for VS - Resharper. You should
try it - very very very useful plugin...
-
Take Surveys. Earn Cash.
There are support for this in the provider
Sorry, i explained incorrectly. I want to say that:
1) You can not choose UTF8 and KOI8 in DDEX provider in drop down list
with encodings.
2) KOI8 not supported in FbClient
If you know what are the equivalent .NET Encodings i will be glad to add
What am I doing wrong?
Check for correct DB file path. I have no other ideas what can it be...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
Seems I have lost myself. All these changes care about fbclient vs.
fbemded DLL name?
In my case yes, but i think other people may want to specify full path
to client dll. What should i do if my application should work with both
embedded and normal server or on mono in windows and linux or
Hi!
What do you think about proposition to add in connection string a new
parameter called ClientLibrary which will be used with ServerType = 1.
Rules may be next:
1) If ServerType = 0 then ClientLibrary ignored
2) If ServerType = 1 and ClientLibrary not specified then behavior
is same as
Do you think with specified path to DLL?
I think path should be optional.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT
Yes, but this will not work with DllImport. It accepts only constant
string as param. And using LoadLibrary will work only on Windows, so for
Linux/Mono it will be out.
BTW if the DLL is in standard dirs there's no problem with loading,
isn't it?
The problems are in
Looked in your codes - looks cool :-)
Yet one way to make that wee need is to _compile_ concrete classes from
their sources using
System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(...)
Steps are next:
1) Make interface IFbClient
2) Make concreate class template, for example:
Edited both machine.configs and runned all .reg files and DDEX start
working :-)
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on
It's because it's view. Neither provider for MS SQL generates update for view.
Maby it's MS SQL's provider issue ;-)
Yes, there's a problem. I'll try to look at it.
Thanks!
-
Take Surveys. Earn Cash. Influence the
Didn't you find who delete quotes when command formatting?
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business topics
Yes.
BTW can you send me a test case, I try to have a look at the problem.
But what test do you want? You can take any table with BIGNINT field and
create for example UPDATE command oh this field... I can sent you
screenshots if you want.
If I create update command for TableAdapter, it creates me paramaters as
objects...
Hmm, very strange... I'll look at home later...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay
If I create update command for TableAdapter, it creates me paramaters as
objects...
Tested in my VS. Look
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
If I create update command for TableAdapter, it creates me paramaters as
objects...
Tested in my VS. Look at screenshot.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and
Can you provide some steps how to reproduce this bug?
Seems i understood why you can't reproduce the bug. I think you tried
reproduce it on tables, but i'm using views and seems on tables all
works completely diffirent.
So:
1) open your databse and create table like this:
3) Create
And yet one inconvenience. Seems designer knows what fields in table are
primary keys. So why don't it generates UPDATE and DELETE commands
using only this keys in WHERE clause:
... WHERE Id = @Original_Id;
?
-
Take
I'll loose a part of text. So
1) open your databse and create table like this:
CREATE TABLE _Test (Id INT PRIMARY KEY, Int64 BIGINT, String
VARCHAR(100));
2) Create view like this:
CREATE VIEW Test AS SELECT * FROM _Test;
Alexander, don't make too fast conclusions, it doesn't support visual
inheritance only for Strip-Elements so far, at least DataGridView you can
inherit for sure
Generally you can inhetit strip elemets, but you can't change them in
inherited form, so for me this equal to feature absence.
And
Have you problems with English? I can write in russian.
It would be nice.
I didn't said, that i see a lot of sense in not being able to edit Strip
Controls in inherited form. But i said so far, that means, that microsoft
is aware of this problem, and it might be solved in next Visual Studio.
Use IDataAdapter's RowUpdated event.
Did you use ADO.NET 2.0? Maby i'm stupid but i can't find even something
similar there...
I want to make form for editing table. I connected to database and
generated DataSet, BindingSource and TableAdapter.
Now i need to make inserting.
Table consists
easy ;) carlosga05 at gmail.com
Sent...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business topics through brief
Well, creating case sensitive tables is like playing with a fire.
But this isn't problem of FB provider, this quotation is handled by VS.
But MS SQL also supports quoted identifiers in and []. I'm using in
my MS SQL databases fields with names equals to reserved words. For
example i have few
It's not wrong. ;)
Why provider decide to select for this parameter Int32 type? Why don't
it use object, boolean, string, deciamal and so on... I think provider
can generate correct type ;-)
-
Take Surveys. Earn Cash.
I have yet two questions:
1) DataModules. In delphi there is some kind of units, similar to forms,
which i can use for placing non visual components such as connections,
transactions, datasets and datasources. So i can place all my datasets
inside this datamodule and use it where i need. It's
For example, binding to the same object created for this is your friend. :)
Not understand you :-/ My english is not good :-(
Cause DS in ADO.NET is complete offline image of data, it's filled always
with all data from select.
But you can create/download layers with work i.e. with
Hi!
I'm using FB.NET Privider 2.1 with DDEX 2.0.1.
When i click Add query in DataSet designer on table adapter and choose
generating new UPDATE or INSERT command then provider generates simple
words UPDATE or INSERT and that's all.
I've tried generation of commands for vews. For tables seems
Is the view updatable?
Yes. It simle alias for table:
CREATE VIEW Notes AS SELECT * FROM _Notes;
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to
In past i programmed with Delphi, so i don't understand some conceptions
of ADO.NET.
1) For example i posted UPDATE command for record. Some fields of record
was changed in triggers inside databse, so i need refresh record from
database right after update. In delphi i has RefresSQL command for
How do you generate insert commands? I doubt that you could generate
INSERT ... RETURNING command, as .NET provider should support firebird
versions older than 2.0, so you should use INSERT ... RETURNING manually.
And make refreshing of dataset after this command?
And where are you storing these rows?
I haven't million records yet. That was just a sample.
BTW how the RefreshSQL procedure in Delphi loads only the changed row? AFAIK
Firebird doesn't return the new row after updating/inserting.
1) For inserting component knows ID because it calls GEN_ID
BTW from my POV seems to be that your application isn't well designed...
I haven't application yet. Now i only try to understand how does it works.
PS Do you know that Visual Studio 2005 does not support visual
inherirtance for .NET 2.0 controls such as DataGridView? This future
worked
Change just record you have updated.
Again.
1) I've generated DataSet and TableAdapter.
2) Called DataSet designer
3) Right click on table adapter and choose Add query
4) Choose Use SQL statement
5) Choose INSERT
6) Generate command like this
INSERT INTO Tab (Name, Description) VALUES (@Name,
Can you send a test database to my private email ??, please
Can't find your e-mail. You can try script below...
/**/
/*** Generated by IBExpert 2006.11.26 08.01.2007 22:12:26
***/
Does this work with previous version? Does the MS SQL work with views (if
you're able to test)?
Don't know about previous versions and MS SQL. In any case this is a bug.
-
Take Surveys. Earn Cash. Influence the Future
Jiri Cincura wrote:
sasha wrote:
1) For inserting component knows ID because it calls GEN_ID before
inserting and than inserts record with alredy known id
2) For updating it use something like @ID variable
So i don't see any problems...
You can do this in ADO.NET. First you get the ID
Another one. If i not confuse (can't check now) MS SQL's provider
generate something like this:
INSERT INTO Table (Name, Description) VALUES (@Name, @Description);
SELECT Id, Name, Description FROM Table WHERE Id =
SCOPE_IDENTITY();
But it's not completely clear for me how does it works...
Don't worry. ;) ADO.NET is easy.
Still don't understand why it's not possible to open a few datareaders
in same connection... Same with transactions...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join
IMHO It sounds like you are doing something that the table adaptor might
not be the best fit for. I have never been a big fan of loading a
million records (or anything close to that in a data set) on a client
machine. No matter what solution you use to refresh you data it's going
to be
1 - 100 of 110 matches
Mail list logo