不同客户数据库之间的数据映射？ [英] Data mapping between to different customer databases?

问题描述

我的VB.net应用程序中有一个包含Customer info表的数据集。

解决方案是一个Windows窗体解决方案。



我需要用户能够以图形方式将他们的客户表链接到我的客户表字段字段，并将字段映射到我的字段。



这样我就可以从他们的数据源中提取信息，而不是我正在使用的原始数据源。



我不知道如何做到这一点？



请帮助



Eric



我的尝试：



因为这是我第一次完成这项任务，所以我一直在谷歌和网站上花费很多时间来看看它是如何完成的。



我看起来越清楚解决方案变得越来越清晰。我甚至都在寻找数据映射工具，但如果我能避免的话，我们不想购买它们。



Eric

I have a dataset within my VB.net application with Customer info table.
The solution is a windows forms solution.

I need the user to be able graphically link their customer table to my customer table field by field, and map there fields to mine.

So that I can pull information from their data source and not the original data source I was using.

I do not have a clue on how to accomplish this?

please help

Eric

What I have tried:

Since this is the first time I had to accomplish such a task, I have been spending many, many hours on google and sites, to see how it could be accomplished.

and the more I look the less clear the solution becomes. I have even looked for data mapping tools but prefer not to have to purchase them if I can avoid it.

Eric

推荐答案

也许这些将帮助您入门：

下载Query Express [< a href =http://www.albahari.com/queryexpress.aspxtarget =_ blanktitle =New Window> ^ ]

Visual SQL查询生成器可在几秒钟内获取数据！ [ ^ ]

GitHub - ActiveDbSoft / active-query-builder-3-net-winforms-samples-vb：用于.NET 3的Active Query Builder - 用于WinForms Edition的VB.NET演示项目 [ ^ ]

数据库对象 [ ^ ]

Dapper.NET - Dapper.NET入门| dapper教程 [ ^ ]

https://www.slant.co/topics/16667/~orms-for-c [ ^ ]

Maybe these will get you started:
Download Query Express[^]
Visual SQL Query Builder to get data in seconds![^]
GitHub - ActiveDbSoft/active-query-builder-3-net-winforms-samples-vb: Active Query Builder for .NET 3 - VB.NET Demo projects for WinForms Edition[^]
Database Objects[^]
Dapper.NET - Getting started with Dapper.NET | dapper Tutorial[^]
https://www.slant.co/topics/16667/~orms-for-c[^]

这篇关于不同客户数据库之间的数据映射？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！