Posts by Felipe Bulle • 387 points
12 posts
-
4
votes4
answers188
viewsQ: SQL Embedded in C#
I have a C# application that uses a Mysql database with Entity Framework. However, the size of the database is ridiculously small, so I don’t think it’s worth having a Mysql database server just to…
-
0
votes3
answers192
viewsA: Formatting with UNION and LINQ in C#
Thank you all, but I found the solution. In the parent class, I added a virtual attribute: [Table("pessoa")] public class pessoa { [Key] public int idPessoa { get; set; } [Required]…
-
3
votes2
answers87
viewsQ: C# Windows Forms Generic Object
I have a Desktop application in C# and need to load a dropdown with an option "All" and the rest coming from a database table. To load the dropdownlist I did something like this:…
-
1
votes0
answers58
viewsQ: Date Filtered Crystal Reports Export (C# Mysql)
I have a Crystal Report object that is bringing the records of a View from a Mysql database. I need these records to be exported to a CSV file and I got this with the following code: private void…
-
2
votes3
answers192
viewsQ: Formatting with UNION and LINQ in C#
I am using the following code to bring a list of companies with CNPJ formatted for Datagridview: dgv.DataSource = db.pessoajuridica .Select(d => new { d.idPessoa, d.nome, d.cnpj })…
-
1
votes2
answers973
viewsA: Inheritance X Composition - Mysql C# Entity
Thanks for the force, Gypsy! Modeling had a problem. Essentially, the client table should have as primary key and foreign key the idpessoa field: Before, she had seen the primary key as a foreign…
-
2
votes2
answers973
viewsQ: Inheritance X Composition - Mysql C# Entity
There was a doubt of inheritance modeling in C# involving the entities Pessoa, Pessoafísica and Pessoalegal, but Gypsy Morrison Mendez helped a lot! Now I have another question in another type of…
-
5
votes2
answers2096
viewsQ: Mysql and C#inheritance modeling
I have a question about modeling a Desktopapplication system in C# with Mysql. Essentially I will have the entities Customer, Supplier, PF and PJ. PF can be a customer or supplier. And PJ can also…
-
1
votes2
answers108
viewsA: C# and Mysql with Aspnetusers, deleted tables
The problem was that the __migrationhistory table was capitalized in the bank... and as it was not found in Initializedatabase, it was cleaned and created again! var migrationHistoryTableExists =…
-
2
votes2
answers108
viewsQ: C# and Mysql with Aspnetusers, deleted tables
I am developing a system with C# (MVC) and Mysql. Everything works perfectly well when using my local database instance. I duplicated this database on Uolhost and that’s when something bizarre…
-
2
votes2
answers180
viewsQ: Field sorting of Join with Line in Mysql (C#, MVC)
I have the following query: query = from p in db.pessoa join f in db.pessoa_origem on p.Pessoa_Origem_Id equals f.Id join s in db.pessoa_status on p.Pessoa_Status_Id equals s.Id join c in db.contato…
-
5
votes1
answer777
viewsQ: Data formatting works on Chrome and does not work on Internet Explorer, or vice versa, with MVC C#
If I wear the model [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd'/'MM'/'yyyy}")] public DateTime data { get; set; } Works perfectly on I.E. but doesn’t work on Chrome. When…