Principais detalhes ao utilizar o Firebird com .NET
Este post não é um passo a passo de como utilizar o Firebird, mas sim para esclarecer boa parte das dúvidas que geram os principais problemas ao trabalhar com o Firebird em .NET que eu e outros usuários já enfrentamos.
O Firebird .NET não adiciona as DLLs no GAC (Global Assembly Cache) quando instalado, então, por muitas vezes você pode encontrar alguns problemas ao utilizar o Firebird no .NET, por exemplo:
Não foi possível localizar o Provedor de Dados .Net Framework solicitado. Talvez ele não esteja instalado.
Isso acontece principalmente ao tentar utilizar o Firebird com DbCommand, um exemplo do comando que dispara esta exception:
DbProviderFactory factory = DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient")
Por isso, vale lembrar aqui alguns detalhes ao utilizar o Firebird no .NET
Definir a propriedade Copy Local = True nas Dlls do Firebird referenciadas no projeto.
Adicionar a DLL ao GAC, para isso, abra o Visual Studio 2008 Command Prompt, localizado no Iniciar => Programas => Visual Studio Tools
Digite gacutil -i FirebirdSql.Data.FirebirdClient (Se você não estiver na mesma pasta em que a DLL se encontra, defina o caminho com a DLL, por exemplo C:\FirebirdSql.Data.FirebirdClient)
Com a DLL adicionada ao GAC, digite gac -l FirebirdSql.Data.FirebirdClient para listar as informações, que deve aparecer conforme abaixo:
The Global Assembly Cache contains the following assemblies:
FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL
Number of items = 1Prestando atenção a detalhes como a Versão (Version) e PublicKeyToken.
Além disso, no web.config (ou app.config no caso de um aplicação winform), adicionar as linhas abaixo:
<system.data> <DbProviderFactories> <remove invariant="CoreLab.Oracle"/> <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral,PublicKeyToken=3750abcc3150b00c" /> </DbProviderFactories> </system.data>
Ao adicionar as linhas acima, fique atendo a detalhes como Version e PublicKeyToken, eles devem ser iguais aos listados quando executamos o comando gacutil -l
Bom, acho que é isso, dúvidas perguntem nos comentários 
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Sites You Should Check Out…
http://www.hyspecs.getlisted.co.nz/cylinder-calculator…
made to find…
the massive number of games that are available over the internet. You will notice as an example that some …
to be in…
also changed. In certain instances individuals find themselves with more free time to spend since much of the work have been relegated to. A number of…
there are…
you could access virtually all kinds of video games you could envisage simply …
close by…
which can introduce them to drug use or different crimes. The contents of the games are determinate which suggests you could be certain of their contents. That is in…
Hi…
I was looking through some of your posts on this site and I conceive this site is really informative! Keep on posting….
of the …
younger people and to arrange them for particular careers. From these games, youngsters will get to see, know and even imagine a few of the benefits…
both the…
games ever developed, you wouldn’t have to carry any system with you apart from your computer, lap prime, …
hair extension courses…
[...]we came across a cool internet site which you might get pleasure from. Take a search when you want[...]…
Great information…
This is certainly significant. Nutritionists looked at this realisation product therefore we are astounded. We are precisely curious about this kind of tasks. Our team appreciate your upcoming suggest, and number the effort in this. Please keep editing…
brown fields…
educative and yet there are also sites that create a demon out of an angel. You need on-line games as a method of partaking the pursuits of your young ones to be sure …
Sites You Should Check Out…
http://www.hyspecs.getlisted.co.nz/cylinder-calculator…
Hey…
I view something truly interesting about your weblog so I saved to bookmarks ….
Net minicab…
Oxshott Taxi!…
praca londyn…
[...]that is the end of this write-up. Right here you will locate some sites that we believe you will enjoy, just click the hyperlinks over[...]…
Trusted builders…
[...]Sites of interest we’ve a link to[...]…
my comment…
Hey very cool site!! Man .. Excellent .. Amazing .. I’ll bookmark your blog and take the feeds also…I am happy to find a lot of useful info here in the post, we need develop more strategies in this regard, thanks for sharing. . . . . ….
my comment…
Great work! This is the type of info that should be shared around the internet. Shame on Google for not positioning this post higher! Come on over and visit my website . Thanks =)…
Hey…
Hey very nice blog!! Man .. Beautiful .. Amazing .. I’ll bookmark your blog and take the feeds additionally…I’m satisfied to find so many helpful info here in the put up, we want develop more techniques on this regard, thank you for sharing….
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Great information…
This is often amazing. Another stare upon this gesture page content and we are shocked. We’re attracted to this type of topics. Type appreciate body hints, and advantages your time with this. Please keep enhancing. They’re totally high priced strateg…
Hey…
I conceive you have mentioned some very interesting details , appreciate it for the post….
Zig Ziglar…
“The foundation stones for a balanced success are honesty, character, integrity, faith, love and loyalty.” …
[...]the time to read or visit the content or sites we have linked to below the[...]……
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
Texte umschreiben mit dem ArticleSpinningWizard…
[...] Texte umschreiben mittels Text Spinning Software durch einen Klick [...]…
Hi…
I’ll right away seize your rss feed as I can not in finding your email subscription link or newsletter service. Do you’ve any? Please permit me realize so that I may just subscribe. Thanks….
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
Its hard to find good help…
I am forever proclaiming that its difficult to find good help, but here is …
modern furniture los angeles…
[...]Principais detalhes ao utilizar o Firebird com .NET @ entendendo.net[...]…
Related……
[...]just beneath, are numerous totally not related websites to ours, however, they are surely worth going over[...]……
Yahoo News…
When checking out Yahoo News today I noticed this…
That’s Right!…
This is a really good blog. Good work!…
2011…
Hi, Neat post. There is a problem with your web site in internet explorer, would check this… IE still is the market leader and a large portion of people will miss your fantastic writing because of this problem….
2011…
As I web-site possessor I believe the content material here is rattling great , appreciate it for your hard work. You should keep it up forever! Good Luck….
… [Trackback] …
[...] There you will find 68606 more Infos: entendendo.net/2009/08/05/principais-detalhes-ao-utilizar-o-firebird-com-net/ [...] …
2011…
F*ckin’ tremendous things here. I’m very glad to see your post. Thanks a lot and i’m looking forward to contact you. Will you kindly drop me a e-mail?…
Its hard to find good help…
I am forever proclaiming that its hard to find good help, but here is …
boiler repairs wolverhampton…
[...]the time to study or stop by the content or web sites we’ve linked to beneath the[...]…
Having problem with frontal hair loss?…
Discover proven and effective frontal hair loss treatment that works now!…
2011…
Wonderful web site. Plenty of useful info here. I am sending it to some friends ans also sharing in delicious. And naturally, thanks for your sweat!…
2011…
Somebody essentially help to make seriously articles I would state. This is the very first time I frequented your web page and thus far? I surprised with the research you made to create this particular publish extraordinary. Wonderful job!…
Trackback…
Find more…
Good Blog…
I discovered your blog on yahoo and checked a few of your early posts. I hope you will continue the very good work. I just added your RSS feed to Feedburner. I’m seeing forward to reading more from you later on!…
Does Smell Matter?…
[...]It’s a known truth that right knowledge can be very important when we are doing something new and especially if it’s important to us.[...]…
Great information…
This is certainly really good. A good checked out good results articles or blog posts therefore we are stupefied. We are precisely attracted to one of these qualities. We appreciate going up on your memo, and cost doing in this. Please keep adding info…
Great information…
This is often impressive. Only one watch and this video material and we are stupefied. We’re attracted to one of these merchandise. A particular appreciate your potential retailer, and estimate doing inside this. Please keep adding information to. The…
[...]Sites of interest we have a link to[...]……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Great information…
This is certainly impressive. Every checked out this skill unwanted and we are startled. We are most certainly interested in this kind of parts. Experts appreciate your very store, and value for money doing inside this. Please keep control. They may be…
Great information…
This can be significant. A miami detective checked out on ease and we are flabbergasted. We are precisely attracted to this kind of actions. A particular appreciate cell phone provider record, and assess doing with this. Please keep enhancing. These ar…
2011…
I would like to thnkx for the efforts you have put in writing this blog. I am hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own blog now. Really the blogging is …