首页 \ 问答 \ Delphi的数据库同步解决方案[已关闭](Database sync solutions for Delphi [closed])

Delphi的数据库同步解决方案[已关闭](Database sync solutions for Delphi [closed])

 我正在寻找一些将Win32 Delphi应用程序的数据与Web应用程序的远程数据库集成的起点。  
 本项目打算解决的问题：  
 1）桌面性能不如vpns。 远程办公室的用户可以使用Web应用程序。  
 2）一些公司更喜欢网络应用程序到桌面应用程序  
 3）移动设备可能会将网络应用作为前端。  
 我已经确定的问题：  
 Web应用程序将运行在基于Unix的系统上，可能是Linux，而桌面应用程序使用NexusDB，而Web应用程序可能是Postgres。 不同的平台和数据库。  
 使用Delphi，似乎Microsoft Sync Framework不适用于此项目。  
 我的第一个想法是为Web应用程序提供标准的REST API，并让桌面应用程序击中API，就好像它是距离本地数据库服务器每隔n分钟一个客户端一样。 我已经看到很多问题了！ 

I am looking for some starting points integrating a Win32 Delphi application's data with a remote database for a web application. 
Problem(s) this project intends to solve: 
1) The desktop does not perform well over vpns. Users in remote office could use the web app instead. 
2) Some companies prefer a web app to the desktop app 
3) Mobile devices could hit the web app as a front end. 
Issues I've identified: 
Web application will run on a Unix based system, probably Linux while the desktop application uses NexusDB while the web application will likely be Postgres. Dissimilar platforms and databases. 
Using Delphi it appears the Microsoft Sync Framework is not available for this project. 
My first thought was to give the web app your standard REST API and have the desktop app hit the API as though it's a client every n-minutes from the local database server. Tons of issues I see with this already!

原文：https://stackoverflow.com/questions/5792504

更新时间：2024-01-10 19:01

最满意答案

 您尝试获取的属性不是Payments元素的属性。 你需要更深层次才能获得它们。 试试这种方式：  
......
doc = XDocument.Load(reader);
var data = doc.Root
              .Elements()
              .Elements("Payments");
foreach(var d in data)
{
    var patti = d.Element("Patti");
    list1.Add(new List<string>()
             { 
                patti.Attribute("Rent").Value, 
                patti.Attribute("Water").Value, 
                patti.Attribute("Electricity").Value, 
                patti.Attribute("Internet").Value 
             });

    var mike = d.Element("Mike");
    list2.Add(new List<string>() 
             { 
                mike.Attribute("Rent").Value, 
                mike.Attribute("Water").Value, 
                mike.Attribute("Electricity").Value, 
                mike.Attribute("Internet").Value 
             });
}
......

The attributes you're trying to get aren't attribute of Payments element. You need to go one level deeper to get them. Try this way : 
......
doc = XDocument.Load(reader);
var data = doc.Root
              .Elements()
              .Elements("Payments");
foreach(var d in data)
{
    var patti = d.Element("Patti");
    list1.Add(new List<string>()
             { 
                patti.Attribute("Rent").Value, 
                patti.Attribute("Water").Value, 
                patti.Attribute("Electricity").Value, 
                patti.Attribute("Internet").Value 
             });

    var mike = d.Element("Mike");
    list2.Add(new List<string>() 
             { 
                mike.Attribute("Rent").Value, 
                mike.Attribute("Water").Value, 
                mike.Attribute("Electricity").Value, 
                mike.Attribute("Internet").Value 
             });
}
......

Delphi的数据库同步解决方案[已关闭](Database sync solutions for Delphi [closed])

最满意答案

相关问答

如何从XDocument获取NameTable？(How do I get a NameTable from an XDocument?)[2021-07-18]

Xml.Linq：将XNode添加到XDocument(Xml.Linq: Add a XNode to a XDocument)[2023-11-18]

将XDocument加载到内存中(Loading XDocument in memory)[2023-06-15]

如何从XDocument更改为XMLDocument代码？(How to change from XDocument to XMLDocument Code?)[2022-09-28]

如何使用XDocument获取属性并将其添加到List(How to use XDocument to get attributes and add them to a List)[2024-01-01]

如何使用XDocument获取属性名称和Elemnt值(How to get the Attribute name and the Elemnt value using XDocument)[2023-01-29]

在构建之后将XDeclaration添加到XDocument(Add XDeclaration to XDocument after it's constructed)[2022-08-30]

从XDocument获取数据(Get data from XDocument)[2023-08-22]

XDocument / Linq将属性值连接为逗号分隔列表(XDocument/Linq concatenate attribute values as comma separated list)[2021-07-09]

获取所有列表项的属性并将其添加到输入(Get attribute of all list items and add them to input)[2021-05-19]

相关文章

最新问答