Problem with the startswith function in NET 9
Hi everyone, I have this request with Odata: http://localhost:5194/NationalStates?$filter=startswith(state, 'NE') This works correctly up to version 8.0.14 for the following packages: MySql.EntityFrameworkCore Microsoft.Extensions.DependencyInjection.Abstractions Microsoft.EntityFrameworkCore among others... When I update these packages to version 9.0.0 or later, they stop working and give an internal mapping error. Any clues about this?
EF Core display up to date data on predefine delay
Hi, I have a C#/WPF project for which I use EF Core (database first) to transact with an SQL database. I am struggling with retreiving fresh data from the server on a predefine delay to be displayed on a dashboard. Scenario is this: I have an entity call Cars. Cars has a property that is a virtual ICollection of ToDo call lstToDo Each ToDo entity has a boolean property call Completed. The data of SQL database can be modified by many users. The dashboard is the application running on a computer that no one is using, and that need to display the latest data from the database every X minutes. So in my scenario everything is working fine except that whenever the property Completed is change, in the database, from false to true (or vice-versa) I am unable to get the new value. I tried using Eager Loading but without any luck.It will catch when a new row has been added to the table, but not when a change happen in an existing row. The eager loading I use: myContext.Cars .Include(c => c.lstToDo) .Load(); myCollectionViewSource.Source = myContext.Cars.Local.ToObservableCollection(); Also, in my context I configured it to use LazyLoading. Any suggestion will be more then welcome
Entity framework core 8 return double quote in Oracle Query
Hi All, My project using .net core 8, when i debug code, always get error ".net core ORA-00942: table or view does not exist" i would like to show data using this query: var data = _db.employee.ToQueryString(); when i debug, the data variable show this: SELECT "e"."id", "e"."empolyee_name", "e"."employee_code" FROM "employee" "e" My Question: how to remove double quote " in EF query to this? SELECT e . id , e . empolyee_name, e . employee_code FROM employee e. i assume the error table or view does not exist because my EF query returning double quote "". how to solve it? thanks & regards.
C# & EF Core : 2 databases with a Customertable and different Columns
Hello, I have a little PRoblem with my DbContext. For Example: I have two Databases both have a Table Customer. One of the Customers has an Extension of our Software so in the Customertable there are for example 3 more columns. Now when i create the DataAccess Class of the Customer Table i add the Structure from the Customer Table and the 3 extra columns. Now when i Request a Customer for the Customer with the extra Columns all is fine. The Request for the other Customer gets an Error that the last 3 Columns from the Model are not in the Table. Unfortunately it is not possible to add the Columns to the other Customer Table. so my Question is: Is there another Way to geht Records from both Databases with one Model Class and one DBContext? I tried NotMapped and Required in DbContext, I tried Raw SQL but nothing worked. The only Solution is to create 2 DbContexts. But in Our Database there are more such Combinations of Table with different Columns. Can anyone help or provide a way to test? Best Regards Philipp
Can I ignore a single return value when multiple values are returned?
Some time ago, the ability to create a function which has multiple return values was created. Yes, I know this can be avoided by using out... but I was curious. In traditional method calls, the return value can be ignored by not assigning the return value to a variable. I recently decided to use multiple return values in a new method because I wanted to avoid having to worry about the method call when the return value isn't always used. Turns out that may have been an oversight on my part, since I as far as I know, I still have to define a return value. For example, if the return signature of "MyFunction" is (int, bool) and I don't need the bool value, I still have to define it (FAIK... which is the point here): private (int, bool) MyFunction(...) { bool error = false; int someReturnValue = 0; //... does something and sets error if there is a problem return (someReturnValue, error); } public void MyUnconcernedCallerFunction() { int ret; bool error; // what if I don't need to worry about the error here? (ret, error) = MyFunction(...); } is there currently any convention that allows me to not declare the bool error value if I don't need it? (i.e. can I ignore the bool part of the return?) SIDE NOTE: Why isn't there a general forum here? While my example is language specific, the question isn't. This is just a general .NET question having to do with data and there are no general options in the "Choose a Label" options. I couldn't post without choosing one so I just picked the one that made the most sense.
Subject: Help & Support Case for ADO.NET Entity Framework back end changes & front end changes with
sync to Model & Database respectively. Help & Support Case From, Abhay Sakunde, Cognizant India Pvt. Ltd. Pune Project Team: MWS CWS Apps Team E-mail ID: (email removed for privacy reasons) Mobile No.: (phone number removed for privacy reasons) To, The Manager, Human Resources Or Development Team, Microsoft India Pvt. Ltd. Pune Subject: Help & Support Case for ADO.NET Entity Framework back end changes & front end changes with sync to Model & Database respectively. Hi Team, Initially using Entity Workflows: Program / Model / Database Priority, we do the design of ADO.NET Entity Data Model & development of database. But once initial process is done if any changes occur either as back end changes into database or front end changes into model then how we can manage or do synchronization between ADO.NET Entity Data Model & Database? How it is done with respect to different type of Entity Workflows i.e. Program / Model / Database Priority? There are following options like Update Model From Database Generate Database From Model In case of Entity Workflows - Model Priority, Initially Model is designed & database is generated. Now if model is changed only then option Generate Database From Model will work either to update existing database or new Database will get created? Please Clarify. In case of Entity Workflows - Database Priority, Initially database exists & model design is generated. Now, if model is changed only then option Generate Database From Model will work either to update existing database or new Database will get created? Please Clarify. Waiting for reply. Please let me know if any detail information required for mentioned feature. Screens: [1] Model & Database Options Thanks & Regards, Abhay Sakunde
