Re: [Firebird-net-provider] Database triggers

2012-04-16 Thread Jiri Cincura
On Wed, Apr 11, 2012 at 1:37 PM, Gerdus van Zyl wrote: > I would prefer it on the FbConnection.Open method. > It would then be like transaction options and > Connection.BeginTransaction. The connection string thus remains > uncomplicated. OTOH the default (generic) isolation level can be specifie

Re: [Firebird-net-provider] bug using COALESCE within CASE via .Net provider

2012-04-11 Thread Jiri Cincura
a) Use latest provider. b) Check inner exception. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- For Developers, A Lot Can Happen In A Second. Boundary is the first t

Re: [Firebird-net-provider] Database triggers

2012-04-11 Thread Jiri Cincura
On Wed, Apr 11, 2012 at 1:50 PM, Mercea Paul wrote: > As i remember well there is a option on restore proces to start  without > activating database triggers. AFAIR on gbak/nbackup only, isn't it? This doesn't apply to ServicesAPI. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincur

[Firebird-net-provider] Database triggers

2012-04-11 Thread Jiri Cincura
Hi *, I started working on option to disable database triggers (DNET-312) when connecting to database. But I'm not sure how to expose it in API. I thought about A) in connection string B) in FbConnection.Open method The connection string seems to me to be more ADO.NET-ish way, though the Open met

Re: [Firebird-net-provider] Working with transactions

2012-04-11 Thread Jiri Cincura
On Wed, Apr 11, 2012 at 9:59 AM, Russell Rose wrote: > The 2nd routine is sometimes called when there is a pending transaction and > sometimes not. Your code should know... -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Documentation

2012-04-10 Thread Jiri Cincura
On Mon, Apr 9, 2012 at 9:28 PM, Steve Harp wrote: > Can anyone point me to documentation for the .NET Provider v2.7? http://msdn.microsoft.com/en-us/library/e80y5yhx(v=vs.80).aspx and sources. :) -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] FbRestore could not drop database

2012-04-10 Thread Jiri Cincura
On Mon, Apr 9, 2012 at 8:05 PM, Steve Harp wrote: > Before calling the Execute method, I’m closing the database and even > disposing of the FbConnection.  What am I missing? Connection pooling? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] CheckMaxPoolSize error

2012-04-05 Thread Jiri Cincura
On Wed, Apr 4, 2012 at 5:39 PM, Erick Perez wrote: > The result is 1 all the time..., i don't understand why Because number of pools isn't number of connections in some particular pool. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

[Firebird-net-provider] [FB-Tracker] Created: (DNET-426) WaitTimeout on transaction options using TimeSpan datatype

2012-04-04 Thread Jiri Cincura (JIRA)
Components: ADO.NET Provider Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor WaitTimeout on transaction options using TimeSpan datatype -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

[Firebird-net-provider] [FB-Tracker] Created: (DNET-425) Single quoted connection string not properly read

2012-04-03 Thread Jiri Cincura (JIRA)
Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Connection string quoted with single quotes isn't correctly parsed by FbConnectionString class. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contac

Re: [Firebird-net-provider] Deadlock problem (possible: DNET-382)

2012-04-03 Thread Jiri Cincura
AFAIR this is fixed since 2.7 [1] [2]. Can you confirm you're not experiencing the issue? [1] http://tracker.firebirdsql.org/browse/DNET-316?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel [2] http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETPr

[Firebird-net-provider] [FB-Tracker] Created: (DNET-424) ADO.NET Entity Relationship with Stored Procedures

2012-04-03 Thread Jiri Cincura (JIRA)
Framework support Affects Versions: 2.6.5 Environment: Visual Studio 2010, Firebird 2.5, and ADO.NET Provider 2.6.5 Reporter: Jiri Cincura Assignee: Jiri Cincura === from thread "ADO.NET Entity Relationship with Stored Procedures" [meubanks] === I

Re: [Firebird-net-provider] ADO.NET Entity Relationship with Stored Procedures

2012-04-03 Thread Jiri Cincura
I created DNET-424, to keep track of it for later. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Better than sec? Nothing is better than sec when it comes to monitori

Re: [Firebird-net-provider] "Specified server type is not correct" when attempting to use the embedded server

2012-04-03 Thread Jiri Cincura
First try it with latest version of provider. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Better than sec? Nothing is better than sec when it comes to monitoring B

[Firebird-net-provider] ADO.NET provider for Firebird 2.7.5 released

2012-03-28 Thread Jiri Cincura
The 2.7.5 version of ADO.NET provider for Firebird is ready for download. http://blog.cincura.net/232764-ado-net-provider-for-firebird-2-7-5-released/ -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

[Firebird-net-provider] [FB-Tracker] Reopened: (DNET-418) Shorter table names for generated queries

2012-03-26 Thread Jiri Cincura (JIRA)
[ http://tracker.firebirdsql.org/browse/DNET-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiri Cincura reopened DNET-418: --- > Shorter table names for generated quer

[Firebird-net-provider] [FB-Tracker] Created: (DNET-423) rdb$field_sub_type for numeric computed column

2012-03-26 Thread Jiri Cincura (JIRA)
Provider Affects Versions: 2.7 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Directly from my thread "Wrong rdb$field_sub_type for numeric computed column" in firebird-devel: === have a table: recreate table test ( base numeric(15,4

Re: [Firebird-net-provider] Computedby Column Edmx Issue

2012-03-26 Thread Jiri Cincura
DNET-423 -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msaz

Re: [Firebird-net-provider] XNET connection to firebird

2012-03-23 Thread Jiri Cincura
On Fri, Mar 23, 2012 at 10:55 AM, Luigi Piccinni wrote: > Is there a way to specify an XNET connection in the ConnectionString > parameters? No. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Improved "weekly" builds

2012-03-10 Thread Jiri Cincura
On Thu, Feb 2, 2012 at 8:06 PM, Jiri Cincura wrote: > It's now returning > version build from latest SVN sources (so it's actually snapshot > builds now). Hi, I had to change the fetching interval, because SF was blocking my build server, so after a commit it might take s

Re: [Firebird-net-provider] FbValidation bad parameters on attach or create database

2012-03-07 Thread Jiri Cincura
On Wed, Mar 7, 2012 at 7:12 PM, Steve Harp wrote: > Is there a way to check before the Execute() call and verify that the Even when the index in being recomputed, the server should accept connections. And this looks like something malformed you parameter buffer for connect. > database is ready t

[Firebird-net-provider] [FB-Tracker] Created: (DNET-419) Aliases for columns only when needed

2012-03-02 Thread Jiri Cincura (JIRA)
Reporter: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http

[Firebird-net-provider] [FB-Tracker] Created: (DNET-418) Shorter table names for generated queries

2012-03-02 Thread Jiri Cincura (JIRA)
Reporter: Jiri Cincura Assignee: Jiri Cincura Shorter table names for generated queries. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa

[Firebird-net-provider] [FB-Tracker] Created: (DNET-417) ProviderManifestToekn should be provided even without database

2012-03-02 Thread Jiri Cincura (JIRA)
Components: Entity Framework support Affects Versions: 2.7 Reporter: Jiri Cincura Assignee: Jiri Cincura ProviderManifestToekn should be provided even without database, because it might be needed to create the database from context. -- This message is

[Firebird-net-provider] [FB-Tracker] Created: (DNET-415) FbService.StartTask is conditionally opening connection, but not closing it

2012-03-02 Thread Jiri Cincura (JIRA)
Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.7 Reporter: Jiri Cincura Assignee: Jiri Cincura FbService.StartTask is conditionally opening connection, but not closing it -- This message is automatically generated by JIRA. - If you

[Firebird-net-provider] [FB-Tracker] Created: (DNET-416) FbService.QueryService is conditionally opening connection, but not closing it

2012-03-02 Thread Jiri Cincura (JIRA)
provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.7 Reporter: Jiri Cincura Assignee: Jiri Cincura FbService.QueryService is conditionally opening connection, but not closing it -- This message is automatically generated by JIRA

Re: [Firebird-net-provider] Can't add a server connection to firebird database through visual studio 2005

2012-03-02 Thread Jiri Cincura
On Mon, Feb 27, 2012 at 6:59 PM, Pliachas Paschalis wrote: > the connection wondow closes after i make any change on it or try to write > on to it. > What is wrong? Your DDEX installation is broken. Very likely the VS host process is unable to load the FirebirdClient assembly according to machine

[Firebird-net-provider] [FB-Tracker] Created: (DNET-414) Properties on FbServerProperties should be methods

2012-03-01 Thread Jiri Cincura (JIRA)
: 2.7 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Properties on FbServerProperties should be methods, because there's a possibly long operation going to be executed and should be clear, that it's not a property but a call actually.

[Firebird-net-provider] [FB-Tracker] Created: (DNET-413) FbServerProperties is not closing connection

2012-03-01 Thread Jiri Cincura (JIRA)
Affects Versions: 2.7 Reporter: Jiri Cincura Assignee: Jiri Cincura FbServerProperties is not closing connection -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http

Re: [Firebird-net-provider] connection pooling - connection not closing after lifetime over

2012-02-19 Thread Jiri Cincura
On Mon, Jul 25, 2011 at 11:04 AM, Jiri Cincura wrote: > Might be a bug. I'll look at it. Bug. Fixed now. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3ren

Re: [Firebird-net-provider] upgrading to 2.7.0 "Failure adding assembly to the cache:"

2012-02-09 Thread Jiri Cincura
On Thu, Feb 9, 2012 at 9:06 AM, Net Newbie wrote: > how to solve it? Install the .NET Framework for which the assembly was compiled, if you want to use this one. Or download version you have installed in you OS. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.

[Firebird-net-provider] Improved "weekly" builds

2012-02-02 Thread Jiri Cincura
Hi *, I've improved the http://netprovider.cincura.net/ . It's now returning version build from latest SVN sources (so it's actually snapshot builds now). Again could be unstable, not a good idea to put it to production. PS: It's reading the build from my internal CI server, that is really old an

Re: [Firebird-net-provider] Is CF still supported?

2012-02-01 Thread Jiri Cincura
On Wed, Feb 1, 2012 at 4:14 PM, Ivan Arabadzhiev wrote: > Is the provider expected to still work on .Net CF? Does anyone actually Yes, it is. But you'll probably need to do some changes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

[Firebird-net-provider] [FB-Tracker] Created: (DNET-407) SQLGen for EF.Migrations

2012-01-21 Thread Jiri Cincura (JIRA)
: Jiri Cincura Assignee: Jiri Cincura Priority: Minor SQLGen for EF.Migrations -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more

Re: [Firebird-net-provider] Integration with Visual Studio

2012-01-19 Thread Jiri Cincura
On Thu, Jan 19, 2012 at 9:57 AM, Russell Rose wrote: > The firebird client 2.7.0 seems to require a gacutil from .net 4.0. If you have the .NET 4 version then yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Computedby Column Edmx Issue

2012-01-17 Thread Jiri Cincura
Looks like a wrong sub type is stored in system tables. I'll follow up with core team. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Keep Your Developer Skills Curre

Re: [Firebird-net-provider] Computedby Column Edmx Issue

2012-01-17 Thread Jiri Cincura
On Tue, Jan 17, 2012 at 4:00 PM, Muthu Annamalai wrote: > The datatype of other columns that is showing properly is Numeric(15,4). The > datatype of the computedby column is Numeric(15,8). I thought the decimal > digits might be a problem, I created a numeric(15,4) domain and used that in > the co

Re: [Firebird-net-provider] Computedby Column Edmx Issue

2012-01-16 Thread Jiri Cincura
On Mon, Jan 16, 2012 at 7:25 PM, Muthu Annamalai wrote: > numeric(15,4) What's the datatype of other columns? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Keep Yo

Re: [Firebird-net-provider] Integration with Visual Studio

2012-01-16 Thread Jiri Cincura
On Mon, Jan 16, 2012 at 3:49 PM, Russell Rose wrote: > When I try to type anything into the 'Add connection' it crashes. Very likely wrong machine.config. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] The provider is creating incompatible code to Firebird

2012-01-08 Thread Jiri Cincura
You have to rewrite your query. CROSS APPLY is currently not supported by server and there's no direct (general) rewrite with other operators. :( -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] A sugestion that can be helpfull

2012-01-08 Thread Jiri Cincura
On Sat, Jan 7, 2012 at 1:41 PM, Marco Aurelio Castro wrote: > I would like to > suggest reduce the size of the aliases to decrease the size of the query. > Example, turns GroupBy1 to G1 and so on. This would be very helpfull. Put it to tracker. -- Jiri {x2} Cincura (x2develop.com founder) http:

Re: [Firebird-net-provider] Storing and retrieving images from Firebird BLOB field

2012-01-02 Thread Jiri Cincura
There's nothing special. You'll get transparently the content of blob column(s) in FbDataReader as array of bytes (byte[]). -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Is running in medium trust possible?

2011-12-23 Thread Jiri Cincura
On Fri, Dec 23, 2011 at 11:32 AM, Scott Price wrote: > The initial basic tests I've performed have it throwing security > exceptions in Medium and High trust environments in a .NET4 environment, > even when recompiled with the AllowPartiallyTrustedCallers, as it seems > to fail when the FbConnecti

[Firebird-net-provider] ADO.NET provider for Firebird 2.7 released

2011-12-19 Thread Jiri Cincura
Hi *, I’m happy to bring you early Christmas gift packed as ADO.NET provider for Firebird version 2.7. This version brings important bug fixes [1] and logging improvements [2]. This release wouldn’t be possible without support of people/companies using provider actively. Big thanks to them. You

Re: [Firebird-net-provider] same connection for VS SqlDataSource, controls and FB commands

2011-12-18 Thread Jiri Cincura
On Sun, Dec 18, 2011 at 11:46 PM, Net Newbie wrote: > or some other advantage? Proper layering of your application is probably one reason. Your DAL should not be tightly coupled with your presentation layer. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3r

Re: [Firebird-net-provider] same connection for VS SqlDataSource, controls and FB commands

2011-12-18 Thread Jiri Cincura
On Sun, Dec 18, 2011 at 12:20 AM, Net Newbie wrote: > how to do this in a better way? Look at connection pooling topic at MSDN. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Error returning timestamps

2011-12-09 Thread Jiri Cincura
On Fri, Dec 9, 2011 at 12:52 AM, Sql Sql wrote: > getdToString Where did you get this method? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Cloud Services Checklis

Re: [Firebird-net-provider] NuGET package for FirebirdSql.Web.Provider

2011-12-09 Thread Jiri Cincura
On Thu, Dec 8, 2011 at 7:29 PM, Mercea Paul wrote: > It would be useful and comfortable . Sure. I'll keep the message there and according to number of replies I'll do it w/w/o priority. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] documentation on FirebirdSql.Data.Isql.FbBatchExecution

2011-11-22 Thread Jiri Cincura
On Tue, Nov 22, 2011 at 3:36 PM, Sam Carleton wrote: > I went searching for documentation, but cannot find any.  Anyone know where > this class, and all the classes within the FirebirdSql.Data.Isql namespace > are documented? Except code itself, probably nowhere (considering some up-to-date and c

Re: [Firebird-net-provider] Deadlock problem (possible: DNET-382)

2011-10-26 Thread Jiri Cincura
Hi, I was working on related problem and came to need to fix this as well. I think, also CheckTransactionState calls should be under lock, don't you think (supposing the lock there is needed - I'm still evaluating all possible cases related to GC thread with respect to server)? -- Jiri {x2} Cinc

Re: [Firebird-net-provider] Weird compiler errors using most recent Firebird ADO.NET provider

2011-10-16 Thread Jiri Cincura
On Sun, Oct 16, 2011 at 2:35 PM, Alexander Riske wrote: > > Does anybody have an idea what might be wrong here? Do I miss something > important ? Probably you're targeting wrong framework version. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] ADO.NET Entity Data Model and Telerik OpenAccess ORM not recognizing Firebird DataSource

2011-10-05 Thread Jiri Cincura
On Wed, Oct 5, 2011 at 12:25 PM, Go Green wrote: > I am able to add Firebird connection only via DSN in the Server Explorer. Then DDEX is not properly installed. Check the readme file. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] ADO.NET Entity Data Model and Telerik OpenAccess ORM not recognizing Firebird DataSource

2011-10-05 Thread Jiri Cincura
On Tue, Oct 4, 2011 at 8:51 PM, Go Green wrote: > I read somewhere (probably Firebird's site) that Firebird supports Entity > Model with its data provider for .NET. While working on .NET 4.0 > application, I tried to add Firebird data source to my model, but Firebird > is not listed in the availab

Re: [Firebird-net-provider] Entity Framework

2011-10-04 Thread Jiri Cincura
On Tue, Oct 4, 2011 at 5:44 PM, Muthu Annamalai wrote: > It seems like the provider is issuing select statement for each record and No it's not. It's doing it in one query. BTW provider isn't issuing any query. It's just sending commands requested by EF: > it takes a while (8 min) to retrieve al

Re: [Firebird-net-provider] Entity Framework

2011-10-04 Thread Jiri Cincura
On Tue, Oct 4, 2011 at 2:54 PM, Muthu Annamalai wrote: > My doubt is the ObjectSet.ToList is the way it is supposed to work ? when we > prepare sql statement manually to retrieve records we only write once and not > one for each record. Secondly the problem in using the fast load "From > statem

Re: [Firebird-net-provider] Entity Framework

2011-10-04 Thread Jiri Cincura
On Tue, Oct 4, 2011 at 1:25 AM, Muthu Annamalai wrote: > When I use ObjectSet.ToList, the provider creates an select statement for > each and every record in the list and it takes forever to load an list of > 1 records. > > > > But instead if I use like > > “From item in Objectset select item.

Re: [Firebird-net-provider] Deploy: Unable to find the requested .Net Framework Data Provider

2011-10-04 Thread Jiri Cincura
On Tue, Oct 4, 2011 at 12:03 AM, meubanks wrote: > I have a web application that I have completed and I am now trying to deploy > it onto a Windows 7 machine. IIS is setup and ready but when I try to access > the web site I get this message: "Unable to find the requested .Net > Framework Data Prov

Re: [Firebird-net-provider] What is the API to backup the database to a local file

2011-09-28 Thread Jiri Cincura
On Tue, Sep 27, 2011 at 8:28 PM, Pierre Arnaud wrote: > I wanted to know if there is some hidden API in the Firebird .NET provider > which would allow me to backup a remote database to a local file (I mean > local on the client machine), just like what can be achieved with GBAK : > > http://www.fi

Re: [Firebird-net-provider] ADO.NET Entity Framework 4.1 with Views

2011-09-23 Thread Jiri Cincura
http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/ -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- All of the data generated in your IT infrastructure

Re: [Firebird-net-provider] Changing .Net type based on a Domain type

2011-09-22 Thread Jiri Cincura
On Thu, Sep 22, 2011 at 2:45 PM, Sam Carleton wrote: > My current thought is there is some way to associate the > isc_info_sql_type and isc_info_sql_sub_type with the domain type.  So, > along these lines, what is the relationship between a domain type and > the isc_info_sql_type and isc_info_sql_

Re: [Firebird-net-provider] Changing .Net type based on a Domain type

2011-09-22 Thread Jiri Cincura
On Wed, Sep 21, 2011 at 11:51 PM, Sam Carleton wrote: > Can someone shield some light on this? Maybe it's too early in the morning, but I don't know what the question is. :) -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Asp.Net MVC - Log in failure with FbMembership

2011-09-15 Thread Jiri Cincura
On Thu, Sep 15, 2011 at 7:49 PM, Mercea Paul wrote: > Where should I look ? Check whether some exception was thrown. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] ADO.NET Entity Relationship with Stored Procedures

2011-09-13 Thread Jiri Cincura
Is the call made to the database? How you imported the SPs (what results)? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- BlackBerry® DevCon Americas, Oct. 18-20, Sa

Re: [Firebird-net-provider] TransactionScope with EntityFramework 4

2011-08-31 Thread Jiri Cincura
On Wed, Aug 31, 2011 at 12:45 PM, Christian Astúa Rosales wrote: > Everytime I will use my context, will I have to surround my code in > "using(TransactionScope trans = new TransactionScope())"?? Yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.

Re: [Firebird-net-provider] Error using edmgen or edmgen2

2011-08-24 Thread Jiri Cincura
On Wed, Aug 24, 2011 at 12:10 PM, Sibylle Koczian wrote: > Unbehandelte Ausnahme: System.AccessViolationException: Es wurde versucht, im > ge > schützten Speicher zu lesen oder zu schreiben. Dies ist häufig ein Hinweis > darau > f, dass anderer Speicher beschädigt ist. >    bei > FirebirdSql.Da

Re: [Firebird-net-provider] Error using edmgen or edmgen2

2011-08-23 Thread Jiri Cincura
You have to add record into provider factories it to machine.config or app.config. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Get a FREE DOWNLOAD! and learn more

Re: [Firebird-net-provider] EF 4 Error mapping UUID Char(16) to GUID for Stored Procedure Input-Parameter

2011-08-22 Thread Jiri Cincura
On Sat, Aug 20, 2011 at 8:01 PM, Ultimate Venom wrote: > Where can I add a tracker? I think I find a bug with stored procedures >_> > Or maybe you can help me. Tracker is tracker.firebirdsql.org. > I written another stored procedure which receive 3 in parameters and returns > 2 parameters: > Whe

Re: [Firebird-net-provider] .NET Provider 2.6.5 Missing Dependancies

2011-08-21 Thread Jiri Cincura
On Fri, Aug 19, 2011 at 12:17 PM, Ted Whitton wrote: > > Used depends.exe on it and the only missing reference is ieshims.dll even > though I seem to have both x64 and x32 versions of this > dll on my system. We're not using this DLL. Probably something else in your system is kicking in. -- Jir

Re: [Firebird-net-provider] EF 4 Error mapping UUID Char(16) to GUID for Stored Procedure Input-Parameter

2011-08-15 Thread Jiri Cincura
On Tue, Aug 16, 2011 at 03:47, Ultimate Venom wrote: > Some idea to doing it automatically? Write a simple console app to change it every time you update model. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

[Firebird-net-provider] [FB-Tracker] Created: (DNET-389) Recognize #GUID# etc. also for parameters of procedures/functions

2011-08-15 Thread Jiri Cincura (JIRA)
: Improvement Components: Entity Framework support Reporter: Jiri Cincura Assignee: Jiri Cincura Recognize #GUID# etc. also for parameters of procedures/functions -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

Re: [Firebird-net-provider] EF 4 Stored Procedure with UUID Input-Parameter

2011-08-15 Thread Jiri Cincura
On Mon, Aug 15, 2011 at 22:08, Ultimate Venom wrote: > What can I do to force .net EF 4 to read my input variable (DEPART_UUID) > from de SP DEPART_LOGIC_DELETE like a GUID type and not a char type? You can't right now. You have to change it manually in store model. I'll create a ticket in track

[Firebird-net-provider] .NET Framework versions

2011-08-13 Thread Jiri Cincura
Hi *, I'd like to open discussion about versions of .NET Framework we're going to support in 3.0+ versions of .NET provider. 1. I'm strongly thinking about dropping support for .NET 2, because a) it's old, b) the .NET 3.5 doesn't change CLR, just bunch of new stuff, c) upgrade itself is free, d)

[Firebird-net-provider] FirebirdClient on NuGet

2011-08-13 Thread Jiri Cincura
More info at http://blog.cincura.net/232492-firebirdclient-on-nuget/ . -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- FREE DOWNLOAD - uberSVN with Social Coding for S

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 64, Issue 2

2011-08-11 Thread Jiri Cincura
On Thu, Aug 11, 2011 at 15:01, Russell Rose wrote: > On the firebird website, the compact client (2.5.2) indicates that it will > work for .net CF 2.0, but when I tried it, it will only work for .net CF 3.5. >  Is there a version for .net CF 2.0 or is the label on the download page > wrong? Yo

Re: [Firebird-net-provider] Can't sonnect if fiel contains ö?

2011-08-11 Thread Jiri Cincura
On Wed, Aug 10, 2011 at 22:59, Kjell Rilbe wrote: > Ah, it seems to be fixed in 2.6.5.0. Great! > > But the first time I tried, I had forgotten to rename the db file back > from DiamondsSok.fdb with an o without dots. Of course it couldn't find > the file, but the error string was not correctly en

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-266) FbScript removes comments in SP and Trigger source code

2011-08-11 Thread Jiri Cincura
On Wed, Aug 10, 2011 at 19:07, Charlie Xiong wrote: > Well I pull the source and made a quick change to keep the comments. > Works like a charm. Feel free to share it. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-266) FbScript removes comments in SP and Trigger source code

2011-08-10 Thread Jiri Cincura
On Tue, Aug 9, 2011 at 19:26, charlie wrote: > Wonder if there has been a fix for this issue?   (removing comments within > fbscript) No. It's still open. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] can i cache table schema?

2011-08-02 Thread Jiri Cincura
On Tue, Aug 2, 2011 at 11:46, korkless wrote: > i have a service which use a dbdataadapter every minute to insert data into > a single table (the istance is recreate every time becouse i need thread > safety), i see that it calls every time the method > FbDataReader.GetSchemaTable to get the schem

Re: [Firebird-net-provider] VS2010 and Entity Framework: All parts of the key must be non nullable

2011-07-26 Thread Jiri Cincura
On Tue, Jul 26, 2011 at 14:13, Alexian wrote: > not explained in the readme There's no readme related to EF. Only for DDEX and DDEX is not needed to EF. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] VS2010 and Entity Framework: All parts of the key must be non nullable

2011-07-26 Thread Jiri Cincura
On Tue, Jul 26, 2011 at 12:08, Alexian wrote: > but when I try to generate my first model, all > entities do not have relationships and the fields are all keys. Thus in the > list of messages for each field an error appear: "is not valid. All parts of > the key must be non nullable". You're proba

Re: [Firebird-net-provider] connection pooling - connection not closing after lifetime over

2011-07-25 Thread Jiri Cincura
On Mon, Jul 25, 2011 at 10:45, Gerdus van Zyl wrote: > Is this a bug or is it by design? Might be a bug. I'll look at it. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Howto retrieve returning values from insert statement?

2011-07-13 Thread Jiri Cincura
On Wed, Jul 13, 2011 at 08:15, Ulrich Groffy wrote: > Is there any build in functionality when I use the FBCommandbuilder for > creating the insert statement? No. The command creation is mainly handled by DbCommandBuilder. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ |

Re: [Firebird-net-provider] Howto UDF Csharp

2011-07-09 Thread Jiri Cincura
Right now, you can't use C# to write UDFs. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- All of the data generated in your IT infrastructure is seriously valuable. W

Re: [Firebird-net-provider] FBParameter

2011-07-07 Thread Jiri Cincura
On Thu, Jul 7, 2011 at 14:29, Ulrich Groffy wrote: > what excactly is the purpose of the property > > FBParameter.SourceVersion ?? > > When is it usefull to use? http://msdn.microsoft.com/en-us/library/system.data.idataparameter.sourceversion.aspx -- Jiri {x2} Cincura (x2develop.com founder) ht

Re: [Firebird-net-provider] Updating data inside a DataGridView

2011-07-05 Thread Jiri Cincura
On Tue, Jul 5, 2011 at 15:06, Ulrich Groffy wrote: > I need some help for understanding how to update data inquired from a > parametrised sql statement inside a DataGridView. > > I added two parameters to the DataAdapter.UpdateCommand. The > DataGridView.DataSource is assigned to a DataTable obj

Re: [Firebird-net-provider] Windows CE 5

2011-07-03 Thread Jiri Cincura
On Sat, Jul 2, 2011 at 22:15, Djordje Radovanovic wrote: > is there any compiled DLL provider for CE 5 to make my day http://www.firebirdsql.org/en/net-provider/ -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Windows CE 5

2011-06-30 Thread Jiri Cincura
On Thu, Jun 30, 2011 at 08:46, Djordje Radovanovic wrote: > What version of Firebird.NET provider does support Windows CE 5? Any. If you build it for Compact Framework. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Is Firebird good embedded DB for ASP.NET?

2011-06-27 Thread Jiri Cincura
On Mon, Jun 27, 2011 at 10:24, marius adrian popa wrote: > I have answered and  modified the wikipedia article about ebedded firebird > now is possible to use firebird in multithreaded env > http://stackoverflow.com/questions/6436810/is-firebird-good-embedded-db-for-asp-net-which-else/ Good job.

Re: [Firebird-net-provider] For 2.6x Mono 2.10.x is required

2011-06-20 Thread Jiri Cincura
On Mon, Jun 20, 2011 at 21:09, marius adrian popa wrote: > At least i see that it needs .net 4.0 and that is required Depends on build targets. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] error when i try to compile with mono linux release

2011-06-20 Thread Jiri Cincura
On Mon, Jun 20, 2011 at 22:02, marius adrian popa wrote: > I get SSDLToFB.tt not found when i do a build to the project It's in SVN (http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Entity/SSDLToFB.tt?view=log). But actually you don't need

Re: [Firebird-net-provider] Views and Entity Framework

2011-06-05 Thread Jiri Cincura
On Sat, Jun 4, 2011 at 19:02, Takeshi Kabuto wrote: > "Warning    6    Error 6013: The table/view 'Firebird.Firebird.ORDERS' does > not have a primary key defined and no valid primary key could be inferred. > This table/view has been excluded. To use the entity, you will need to > review your sche

Re: [Firebird-net-provider] Views and Entity Framework

2011-06-04 Thread Jiri Cincura
On Sat, Jun 4, 2011 at 17:18, Takeshi Kabuto wrote: > Am I doing something wrong or the reason is that #PK_GEN# workaround is > not supported for views? You're doing something wrong. It is supported on views. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3

Re: [Firebird-net-provider] ADO.NET provider for Firebird version 2.6.5 released

2011-06-03 Thread Jiri Cincura
On Fri, Jun 3, 2011 at 14:34, Jiri Cincura wrote: > http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.6.0/ The correct address should be, of course, http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.6.5/. Thanks Alex for pointing out. :) -- Jiri

[Firebird-net-provider] ADO.NET provider for Firebird version 2.6.5 released

2011-06-03 Thread Jiri Cincura
Hi *, I'm proud to announce new version of ADO.NET provider for Firebird - 2.6.5. It's half maintenance release, half new features. You can find all bug fixes in tracker [http://tracker.firebirdsql.org/secure/IssueNavigator.jspa?reset=true&&pid=10003&fixfor=10400&sorter/field=issuekey&sorter/orde

Re: [Firebird-net-provider] question about 3.5 support

2011-05-27 Thread Jiri Cincura
On Fri, May 27, 2011 at 15:33, korkless wrote: > i'm trying to compile the last code from the trunk. And that's the problem. Use stable tags. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] question about 3.5 support

2011-05-27 Thread Jiri Cincura
On Fri, May 27, 2011 at 14:41, korkless wrote: > hi, i have downloaded code from > https://firebird.svn.sourceforge.net/svnroot/firebird/NETProvider/trunk , > the problem is that the project is  for 4.0 compiler only so i want know if > there's same other repository with code for 3.5 compiler. > (

Re: [Firebird-net-provider] A defined parameter value becomes null when executing command?

2011-05-20 Thread Jiri Cincura
What version of provider you're using? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- What Every C/C++ and Fortran developer Should Know! Read this article and learn

Re: [Firebird-net-provider] Firebird connection error: consistency check, cannot start thread

2011-05-09 Thread Jiri Cincura
This is more for support list. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehens

[Firebird-net-provider] SQL generator testing

2011-05-09 Thread Jiri Cincura
Hi *, I fixed some bugs in SQL generator for EF. Though only few people were affected, these were bad ones. Because it was in a very deep code, it affects a lot of code paths. I would be nice if you could grab nightly build and see whether all commands are properly created (Firebird server will th

Re: [Firebird-net-provider] Stored Procedures & Entity Framework

2011-04-27 Thread Jiri Cincura
It's probably bug. Create a tracker ticket for it, please. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- WhatsUp Gold - Download Free Network Management Software The

<    1   2   3   4   5   6   7   8   9   10   >