entity framework core
10 TopicsUsing Microsoft Purview glossary and business terms as knowledge for Copilot Agents?
Hi everyone, I'm exploring the knowledge management capabilities of Copilot Agents and had a question regarding integration with Microsoft Purview. In several demos, I've seen Copilot Agents configured with business context manually through features such as Glossary, Synonyms, and other knowledge-related settings. This makes sense when the information only exists within the agent configuration. However, in our case, we already have a significant amount of business metadata managed in Microsoft Purview, including: Business glossary terms Synonyms and alternative business names Definitions and descriptions Data domain ownership and governance information Metadata linked to underlying SQL data sources My question is whether there is a way for a Copilot Agent to leverage this information directly from Purview instead of maintaining a separate glossary and synonym repository within the agent itself. Ideally, we would like Purview to remain the single source of truth for business terminology and semantic definitions, with Copilot consuming that context dynamically. Has anyone implemented or evaluated an architecture like this? Specifically: Can Copilot Agents directly use Purview glossary assets and business metadata? Is there any native integration currently available? Would this require a custom solution (for example, retrieving Purview metadata through APIs and exposing it to the agent as a knowledge source)? Are there any best practices for keeping business context synchronized between Purview and Copilot? I'd be very interested to hear how others are approaching this challenge and whether Microsoft has any roadmap or recommended patterns in this area. Thanks in advance!38Views0likes0CommentsEstou tentando acessar a conta Microsoft no PC e no celular, mas não estou conseguindo.
Mano, eu preciso de ajuda. Estou tentando acessar a conta Microsoft no PC e no celular, mas não estou conseguindo. Entrei em contato com o suporte para pedir ajuda, pois não consigo trocar a senha. Não estou recebendo o SMS no celular, não chega de forma alguma. O suporte disse que não pode fazer nada, pois a segurança é muito forte e eles não conseguem acessar. Agora, nem eu, que sou dono da minha conta, também consigo acessar, pois não consigo trocar a senha. Detalhe: chega o código no e-mail, eu coloco o código, não aceita, aí pede o código do SMS. O problema do código do SMS é que ele não está chegando no celular. Esse é o único problema. Aí o suporte falou que é para entrar em contato na comunidade para poder ver se algum engenheiro consegue ajudar. E é aí que está o detalhe, pois ele disse que tem que recuperar acesso da conta do autenticador, mas eu não consigo recuperar porque pede senha. E quando pede senha, eu não consigo acessar, pois a minha senha antiga simplesmente parou de funcionar. E agora não consigo fazer mais nada. Não consigo recuperar o autenticador, não consigo trocar a senha, não consigo jogar os meus jogos e eu não quero perder a minha conta com coisas dentro porque a segurança é tão alta que nem o próprio usuário consegue acessar.82Views0likes0CommentsProblem 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?211Views0likes0CommentsEF 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 welcome293Views0likes0CommentsEntity 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.371Views0likes0CommentsC# & 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 Philipp287Views0likes0CommentsEF Core : foreign key column with same name as existing navigation property
I want to use EF Core to map a legacy database. I cannot scaffold as there are hundreds of tables and I am only interested in very few and besides scaffolding generates names for the navigation properties which are not the ones I want. The situation is: I have a required many-to-one relationship linked by a column name that matches the name of the property that I want to give. The code (simplified) is: public class EntityProperty { public ControlType ControlType { get; set; } } public class ControlType { public List<EntityProperty> Properties { get; set; } = new List<EntityProperty>(); } Nothing more is required, eg, I'm not using foreign key properties, just navigation. The problem is, the foreign key column from the EntityProperties table to the ControlTypes is also called ControlType. So, when I try to map it as: builder.HasOne(x => x.ControlType) .WithMany(x => x.Properties) .IsRequired() .HasForeignKey("ControlType"); I want to use EF Core to map a legacy database. I cannot scaffold as there are hundreds of tables and I am only interested in very few. The situation is: I have a required many-to-one relationship linked by a column name that matches the name of the property that I want to give. The code (simplified) is: public class EntityProperty { public ControlType ControlType { get; set; } } public class ControlType { public List<EntityProperty> Properties { get; set; } = new List<EntityProperty>(); } The problem is, the foreign key column from the EntityProperties table to the ControlTypes is also called ControlType. So, when I try to map it as: builder.HasOne(x => x.ControlType) .WithMany(x => x.Properties) .IsRequired() .HasForeignKey("ControlType"); I get the following exception: InvalidOperationException: The property or navigation 'ControlType' cannot be added to the 'EntityProperty' type because a property or navigation with the same name already exists on the 'EntityProperty' type.' The problem is with HasForeignKey, I guess it's because I am adding a shadow property when a "physical" property already exists, but I what I really mean to say is to use a different column name to link the two entities: what I want is to be able to specify a "not standard" column name for the foreign key, which I am not able to. I do not have a foreign key property, only a navigation property, and I do not want to have one.Solved3KViews0likes1CommentCan 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.452Views0likes0CommentsSubject: 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 Sakunde806Views0likes1Comment