tag:blogger.com,1999:blog-15237920.post7173537439438528475..comments2023-11-05T09:19:31.491-03:00Comments on Francisco Figueiredo Jr Activities: Initial EF-6 support added to NpgsqlFrancisco Juniorhttp://www.blogger.com/profile/06807288057155551345noreply@blogger.comBlogger44125tag:blogger.com,1999:blog-15237920.post-79794987502169275742015-08-06T04:30:44.689-03:002015-08-06T04:30:44.689-03:00What a great online source of information about th...What a great online source of information about this topic. you have done great work. keep continue to sharing such kinds of post. keep it up.<br />Signature:<br />The place to play all <a href="http://www.unblocked-games-77.com/" rel="nofollow">unblockedgames</a> online. Here you can find every blocked games such as: <a href="https://unblockedgames77online.wordpress.com/" rel="nofollow">unblocked games</a> , unblocked games happy , <a href="http://unblocked-games-77.tumblr.com/" rel="nofollow">unblocked games 77</a> ,<br />Anonymoushttps://www.blogger.com/profile/00123816553128203525noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-46570524064678742092015-07-17T05:09:58.620-03:002015-07-17T05:09:58.620-03:00You’ve written nice post, I am gonna bookmark this...You’ve written nice post, I am gonna bookmark this page, thanks for info. I actually appreciate your own position and I will be sure to come back here.<br />Signature:<br />download free <a href="http://www.descargar-whatsapp.biz/descargar-whatsapp-para-android" rel="nofollow">Descargar Whatsapp Para Android</a> and download <a href="http://www.baixarwhatsapp.biz/baixar-whatsapp-para-celular" rel="nofollow">baixar whatsapp para celular</a> online and <a href="https://descargarwhatsapp01.wordpress.com/" rel="nofollow">descargar whatsapp</a> , <a href="http://baixarwhatsapp1.blogspot.com/" rel="nofollow">baixar whatsapp gratis</a><br />Anonymoushttps://www.blogger.com/profile/04643568444520160618noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-87804811803582074202015-07-15T01:24:38.537-03:002015-07-15T01:24:38.537-03:00Thanks for sharing. I hope it will be helpful for ...Thanks for sharing. I hope it will be helpful for too many people that are searching for this topic.<br />Signature:<br />download <a href="http://www.descargarfacebook.biz/" rel="nofollow">descarga facebook</a> gratis para Android celular and download free <a href="http://www.descargarfacebookapk.com/" rel="nofollow">descargar facebook gratis</a> and <a href="https://sites.google.com/site/descargarfacebooks/" rel="nofollow">descargar facebook gratis</a> , <a href="http://descargarfacebookapk.blogspot.com/" rel="nofollow">descarga facebook</a><br />Anonymoushttps://www.blogger.com/profile/09892653140532172615noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-32297659091894785322014-05-31T23:14:52.391-03:002014-05-31T23:14:52.391-03:00Hi, all!
Sorry for late response.
To all who are...<br />Hi, all!<br /><br />Sorry for late response.<br /><br />To all who are having problems with EF, please, check this post: http://fxjr.blogspot.com.br/2014/02/using-entity-framework-6-with-npgsql-210.html<br /><br />You will need to try Npgsql 2.1.x<br /><br /><br />Bruno and Leonidio, in your case, you will need to use our master branch version. Support for what you are doing will be available in 2.2.x version. <br /><br />像壞人的好人, Currently support for using edmx isn't very good yet. Sorry for that. I'll create a post talking about the current situation with edmx.<br />Francisco Juniorhttps://www.blogger.com/profile/06807288057155551345noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-70928558708492048372014-05-29T11:28:10.183-03:002014-05-29T11:28:10.183-03:00Olá Francisco tudo bem, estou com um erro que talv...Olá Francisco tudo bem, estou com um erro que talvez possa ser um problema do Npgsql. O cenário é o seguinte, minha entidade possui um campo do tipo interval na entidade o campo é mapeado para o tipo TimeSpan na linguagem c#. Quando o EntityFramework gera um insert ele especifica que o tipo correspondente no banco de dados e do tipo time e não interval.<br /><br />{"ERRO: 22007: sintaxe de entrada é inválida para tipo time: \"10.11:12:00\""}<br /><br />INSERT INTO "public"."tab_procedim"("nome","realizado","comentario","previsaoexe","horainicial","horafinal","previsao","dataa","obrig","ativo","procedimgrupo","empsyst","empsystvers","ordem","status","colab","colab_alter","emp") VALUES (E'ASDFASDF',NULL,NULL,TIMESTAMP '2014-05-31T09:00:00.0000000',TIMESTAMP '0001-01-01T00:00:00.0000000',TIMESTAMP '0001-01-01T00:01:00.0000000',TIME '10.11:12:00',TIMESTAMP '0001-01-01T00:00:00.0000000',cast(FALSE as boolean),cast(TRUE as boolean),130,23,0,0,11,3,3,7);<br />SELECT currval(pg_get_serial_sequence('"public"."tab_procedim"', 'id')) AS "id"Anonymoushttps://www.blogger.com/profile/00333142315704738921noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-70286575735918821732014-05-16T15:50:26.712-03:002014-05-16T15:50:26.712-03:00Errata: trocar RETURN por RETURNINGErrata: trocar RETURN por RETURNINGAnonymoushttps://www.blogger.com/profile/00333142315704738921noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-61745485594534593432014-05-16T14:49:24.233-03:002014-05-16T14:49:24.233-03:00Olá Francisco. Estou com o seguinte erro:
null st...Olá Francisco. Estou com o seguinte erro:<br /><br />null store-generated value was returned for a non-nullable member 'id'<br /><br />Estrutura da tabela.<br /><br />CREATE TABLE tab_emp<br />(<br /> id serial NOT NULL,<br /> cnpj text,<br /> ie text,<br /> razao text NOT NULL,<br /> fantasia text NOT NULL,<br /> im text,<br /> obs text,<br /> ativo boolean NOT NULL DEFAULT true,<br /> CONSTRAINT prk_emp PRIMARY KEY (id),<br /> CONSTRAINT unc_emp UNIQUE (razao, cnpj, fantasia)<br />)<br />WITH (<br /> OIDS=FALSE<br />);<br />ALTER TABLE tab_emp<br /> OWNER TO postgres;<br /><br />-- Index: ind_emp_id<br /><br />-- DROP INDEX ind_emp_id;<br /><br />CREATE UNIQUE INDEX ind_emp_id<br /> ON tab_emp<br /> USING btree<br /> (id);<br /><br /><br />-- Trigger: trg_emp_logs on tab_emp<br /><br />-- DROP TRIGGER trg_emp_logs ON tab_emp;<br /><br />CREATE TRIGGER trg_emp_logs<br /> AFTER INSERT OR UPDATE OR DELETE<br /> ON tab_emp<br /> FOR EACH ROW<br /> EXECUTE PROCEDURE trf_reglogs();<br />ALTER TABLE tab_emp DISABLE TRIGGER trg_emp_logs;<br /><br />Possiveis causas do erro:<br /><br />INSERT INTO "public"."tab_emp"("fantasia","razao","cnpj","ie","im","obs","ativo") VALUES (E'asdfasdfasdfasdfasdfasdfas',E'asdfasdfasdfasdfasdfasfasdfas',E'12.013.121/3321-32',E'32165646546546565',NULL,NULL,cast(TRUE as boolean));<br /><br />SELECT currval(pg_get_serial_sequence('"public"."tab_emp"', 'id')) AS "id";<br /><br /><br />Sugestão:<br />INSERT INTO "public"."tab_emp"("fantasia","razao","cnpj","ie","im","obs","ativo") VALUES (E'asdfasdfasdfasdfasdfasdfas',E'asdfasdfasdfasdfasdfasfasdfas',E'12.013.121/3321-32',E'32165646546546565',NULL,NULL,cast(TRUE as boolean)) RETURN "id";<br /><br />Existe uma causa especifica para o erro?Anonymoushttps://www.blogger.com/profile/00333142315704738921noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-86005372156495480762014-02-27T08:31:20.174-03:002014-02-27T08:31:20.174-03:00Hi, Francisco
I have a question for EF6 and new N...Hi, Francisco <br />I have a question for EF6 and new Npgsql.<br />I used NuGet to install Npgsql & EF6. Then, I added data object and dbcontext manually. And, It's worked fine.<br />My question is : How can created data object and object context automatically by edmx ?<br />or it doesn't work ?<br /><br />Thank you for answer. :)<br /><br />像壞人的好人https://www.blogger.com/profile/15427514897976099507noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-89211747797432682132014-02-12T22:41:52.590-02:002014-02-12T22:41:52.590-02:00Encontrei outra pessoa com o mesmo problema.
http...Encontrei outra pessoa com o mesmo problema.<br /><br />https://groups.google.com/forum/#!topic/npgsql-help/97X1QX5WE5k<br /><br /><br />Terei que baixar o codigo pra ver :(.Anonymoushttps://www.blogger.com/profile/02000330795059175917noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-40578495101079493482014-02-09T11:54:52.791-02:002014-02-09T11:54:52.791-02:00Bom dia Francisco, tudo bem?
Estou usando o Npgsq...Bom dia Francisco, tudo bem?<br /><br />Estou usando o Npgsql.2.0.14.3 com EF6.0.2 ja coum o pre instalado também.<br /><br />Não estou conseguindo inserir registros com colunas que tem uma sequence (autoincremento).<br /><br />Segue os codigos.<br /><br />#db<br />CREATE TABLE tb_unidade<br />(<br /> cod_unidade bigint NOT NULL DEFAULT nextval('sq_tb_unidade'::regclass),<br /> cod_pesquisa character varying(3) NOT NULL,<br /> descricao character varying(20) NOT NULL,<br /> CONSTRAINT tbentries_unidade_pkey PRIMARY KEY (cod_unidade)<br />).. <br /><br />#poco<br />[Table("tb_unidade", Schema = "public")]<br /> public class UnidadeEntidade : IEntidadeBase<br /> {<br /><br /> [Key]<br /> [Column("cod_unidade")] <br /> public Int64 Codigo { get; set; }<br /><br /> [Column("cod_pesquisa")]<br /> [MaxLength(3), MinLength(1)] <br /> public string CodPesquisa { get; set; }<br /><br /> [Column("descricao")]<br /> [Required(ErrorMessage="Descrição não foi informada.")] <br /> public string Descricao { get; set; }<br /><br /> }<br /><br />#ef<br /><br />1)<br /> var db = OvniContext.CreateContext();<br /> db.UnidadesContext.Add(item);<br /> db.SaveChanges();<br /><br />2)<br /> var db = OvniContext.CreateContext();<br /> db.Entry(item).State = System.Data.Entity.EntityState.Added;<br /> db.SaveChanges();<br /><br /><br />em ambos os casos aparece a exception:<br /><br />A null store-generated value was returned for a non-nullable member 'Codigo'. <br /><br />O Erro so ocorre para inserções.<br /><br />Poderia ajudar?<br />Anonymoushttps://www.blogger.com/profile/02000330795059175917noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-83832522979075174722014-01-23T09:58:57.660-02:002014-01-23T09:58:57.660-02:00Hi All,
I am trying to connect PostgreSQL 9.3.2 w...Hi All,<br /><br />I am trying to connect PostgreSQL 9.3.2 with EF 6.0.2 using Npgsql 2.x.x.<br />Please suggest me the compatible versions of EF and Npgsql.dll and the working setting in web.config.<br /><br />Thanks in advance<br /><br />BhupendraBhupendra Singh Raohttps://www.blogger.com/profile/08855961598634264909noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-87041926631781755502013-12-27T09:07:44.957-02:002013-12-27T09:07:44.957-02:00<entityFramework>
<providers>
...<entityFramework> <br /> <providers><br /> <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, Npgsql" /><br /> </providers><br /> </entityFramework><br /> <system.data><br /> <DbProviderFactories><br /> <add name="Npgsql Data Provider"<br /> invariant="Npgsql"<br /> description="Data Provider for PostgreSQL"<br /> type="Npgsql.NpgsqlServices, Npgsql" /><br /> </DbProviderFactories><br /> </system.data>tryhp3https://www.blogger.com/profile/15494518517696187888noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-35266696360540199182013-12-27T08:57:37.171-02:002013-12-27T08:57:37.171-02:00I have npgsql 2.1 nad EF6.0.2. My configuration fi...I have npgsql 2.1 nad EF6.0.2. My configuration file is:<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br />For above I have error:<br />Additional information: The 'Instance' member of the Entity Framework provider type 'Npgsql.NpgsqlFactory, Npgsql, Version=2.1.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later;<br /><br />Next I replace NpgsqlFactory to NpgsqlServices and I have:<br />Additional information: The Entity Framework provider type 'Npgsql.NpgsqlServices, Npgsql' registered in the application config file for the ADO.NET provider with invariant name 'Npgsql' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. <br /><br />What is wrong?tryhp3https://www.blogger.com/profile/15494518517696187888noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-71870516595453471732013-12-18T06:23:48.854-02:002013-12-18T06:23:48.854-02:00I want to know when I am adding a record to the Po...I want to know when I am adding a record to the PostgreSql database through Entity Framework the insert query is adding E' preceding every column values Anonymoushttps://www.blogger.com/profile/08084046360079011975noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-3996457246261427312013-11-25T21:19:20.779-02:002013-11-25T21:19:20.779-02:00Hi, I'm receiving the same error malcolm have ...Hi, I'm receiving the same error malcolm have been getting<br />"The 'Instance' member of the Entity Framework provider type 'Npgsql.NpgsqlFactory, Npgsql, Version=2.0.12.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; "<br /><br />I've added the provider long before this error occured to meand i am pretty stomped, any chance you could help me figure out what is going on if i'll send you my project? (it's a tiny tiny one)הסוחר העובד והלומדhttps://www.blogger.com/profile/02950497893984306668noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-69239157702709972362013-11-17T21:21:50.591-02:002013-11-17T21:21:50.591-02:00Hi Francisco Figueiredo Jr.
Thank you.
I'll ...Hi Francisco Figueiredo Jr.<br /><br />Thank you.<br /><br />I'll prepare pull request for you and Npgsql asap, about 2 things: schema file correction, and experimental DbFunctionCommandTree support.KUhttps://www.blogger.com/profile/06507601164347043520noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-60796967237327798582013-11-16T00:22:41.176-02:002013-11-16T00:22:41.176-02:00That's great. KU!
Please, send your patches as...That's great. KU!<br />Please, send your patches as pull request to our github project: https://github.com/npgsql/Npgsql<br /><br />I'd be glad to add your patches to our codebase.<br /><br />Thank you very much for your feedback and support.Francisco Juniorhttps://www.blogger.com/profile/06807288057155551345noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-56957667135785575142013-11-14T09:10:05.947-02:002013-11-14T09:10:05.947-02:00Hi.
I love Npgsql so much. It is significantly go...Hi.<br /><br />I love Npgsql so much. It is significantly good library :)<br /><br />I've fixed some problems in msl/ssdl of Npgsql, when I'm writing my edmx generator tool.<br /><br />Here is link for discussion. I've posted the link for new schema files.<br /><br />https://entityframework.codeplex.com/discussions/468221<br /><br />thanks<br />kenji unoKUhttps://www.blogger.com/profile/06507601164347043520noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-11352571408050716072013-11-12T07:38:32.043-02:002013-11-12T07:38:32.043-02:00I could code my own DbFunctionCommandTree support ...I could code my own DbFunctionCommandTree support code. It goes well.<br /><br />However we may need good edmx generator to ease code generation for StoredProcedures/Functions support.<br />By the way, I'm using VS 2012 Express, so I cannot try EF designer support. Even if it has good generator support.<br /><br />EdmGen2 can generate edmx (ssdl,csdl,msl) for older ObjectContext support with Npgsql provider.<br />It also writes Functions support into ssdl.<br />But we need to write Functions support into msl and csdl in hand work.<br />Probably ssdl needs to be tweaked for Parameter type issue.<br /><br />thanks<br />kenji unoKUhttps://www.blogger.com/profile/06507601164347043520noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-15243211736189051822013-11-07T04:04:41.726-02:002013-11-07T04:04:41.726-02:00I'm actively using Npgsql's EF6 support to...I'm actively using Npgsql's EF6 support to realize WPF data binding.<br /><br />Any chance to have support for DbFunctionCommandTree within NpgsqlServices.TranslateCommandTree?<br /><br />I have to use traditional id generator. It is built as a PostgreSQL function.<br /><br />The function new_seq_id:<br />---<br />CREATE OR REPLACE FUNCTION new_seq_id()<br /> RETURNS character varying AS ...<br />---<br /><br />The edmx summary:<br />---<br /><edmx:Edmx ...><br /> <edmx:Runtime><br /> <edmx:StorageModels><br /> <Schema ...><br /> <Function Name="new_seq_id" StoreFunctionName="new_seq_id" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="public" /><br /> </Schema ...><br /> </edmx:StorageModels><br /> <edmx:ConceptualModels><br /> <Schema ...><br /> <EntityContainer ...><br /> <FunctionImport Name="new_seq_id" ReturnType="Collection(String)"/><br /> </EntityContainer><br /> </Schema ...><br /> </edmx:ConceptualModels><br /> <edmx:Mappings><br /> <Mapping Space="C-S" ...><br /> <EntityContainerMapping ...><br /> <FunctionImportMapping FunctionImportName="new_seq_id" FunctionName="KanauModel.Store.new_seq_id"/><br /> </EntityContainerMapping><br /> </Mapping><br /> </edmx:Mappings><br /> </edmx:Runtime><br /></edmx:Edmx><br />---<br /><br />The class summary:<br />---<br /> public partial class KanauEntities : ObjectContext<br /> {<br /> public ObjectResult<global::System.String> new_seq_id()<br /> {<br /> return base.ExecuteFunction<global::System.String>("new_seq_id");<br /> }<br /> }<br />---<br /><br />It gets ArgumentException from NpgsqlServices.TranslateCommandTree. (passing DbFunctionCommandTree)<br /><br />I'll help you what I can do.<br /><br />thanks<br />kenji unoKUhttps://www.blogger.com/profile/06507601164347043520noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-74341569985585699322013-10-19T14:03:03.963-03:002013-10-19T14:03:03.963-03:00This comment has been removed by the author.boogiemanhttps://www.blogger.com/profile/13035788233647821605noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-36434747435807201302013-10-19T14:02:36.504-03:002013-10-19T14:02:36.504-03:00Hello, please explain how to use NpgsqlFactory.Ins...Hello, please explain how to use NpgsqlFactory.Instance.GetService<br />i got null object when using it with parameter typeof(DbProviderServices).<br />When i decompile source of NpgsqlFactory i see "if" statement with typeof(DbProviderServices), but it didn't work.<br />Thanks for answerboogiemanhttps://www.blogger.com/profile/13035788233647821605noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-67177487878824823682013-10-18T03:09:43.217-03:002013-10-18T03:09:43.217-03:00hi Francisco: Im a coder in china, and i want to m...hi Francisco: Im a coder in china, and i want to make our own interface to support EF, but I dont know how. So if there is any suggestion, please let me know. Thanks very much.<br />Anonymoushttps://www.blogger.com/profile/03457472102321552043noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-39266883234152594522013-08-05T04:51:38.008-03:002013-08-05T04:51:38.008-03:00when u r going to release 2.0.13 stable release......when u r going to release 2.0.13 stable release.... because when we try out beta version with visual studio 2012, end-up with errors...we cannot even see npgsql data provider inside providers list....This one is pretty urgent, so Please reply..... Thank youGLanehttps://www.blogger.com/profile/07553229038931189012noreply@blogger.comtag:blogger.com,1999:blog-15237920.post-83200379642996233042013-07-08T22:26:04.813-03:002013-07-08T22:26:04.813-03:00Hello, Francisco Figueiredo Jr,
Error "featu...Hello, Francisco Figueiredo Jr,<br /><br />Error "feature not implemented" in mono 3.0.12 of mvc4 (. Net 4.0) site, and edmgen has not been able to use (at present does not seem to support the ef-6).清风https://www.blogger.com/profile/17387800887348292683noreply@blogger.com