Завершено

Load XML file into database (C#/SQL)

I need a C# function that can take a specified XML string and convert it into a SQL table with a few (4-8) additional simple fields added that are not in the XML. The C# function will validate each field based on the PAD specification format. If a field fails validation, the function will return an appropriate identifying error. If all of the XML fields are correct, the fields are saved to a new record in the database.

The PAD specification has Regex validation on every field and the function should account for that, as well as the SQL data field.

The XML is complicated, but you can likely just convert it to XSD and use that as the basis for the database creation.

The PAD format is very well-documented.

[login to view URL]

[login to view URL]

[login to view URL]

What I expect:

Create a small winform project that demos the function. Visual Studio 2017, C# .net (4.6~)

Create a new database and table for the PAD structure and other additional columns.

Create a form with a multiline textbox that you paste in the XML. A button calls the function and imports that XML into the database table in the appropriate fields or throws an appropriate error.

Квалификация: Программирование на C#, SQL, XML, .NET

Показать больше dumping xml file database contents, xml file database using vbnet, save xml file database, example xml file database vbnet, inser xml file database, net insert xml file database, sql server insert xml file database, xml file database table php, insert xml file database vbnet, aspnet vbnet insert xml file database, load excel file database php function, procedure sql insert xml file database, save xml file database php, insert xml file database sql server xml type, import xml file database using php, large xml file database php, load csv file to azure sql database

О работодателе:
( 5 отзыв(-а, -ов) ) Clearwater, United States

ID проекта: #20236347

Поручен:

okzhang321

Hello. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful C# and SQL programmer. I ha Больше

$100 USD за 1 день
(27 отзывов(-а))
5.1

23 фрилансеров(-а) в среднем готовы выполнить эту работу за $189

Piao217

Hi I see you are looking for someone to read xml file and convert into SQL Table. I am expert in C , C++, C#, .NET Framework, Software Architecture, Python, Java, SQL, etc.. So I am very interested in your project and Больше

$250 USD за 7 дней(-я)
(89 отзывов(-а))
7.5
adeelpirzada

Hi Good Day, My video portfolio: [login to view URL] My Reputation: I am rated in top 3% freelancers here on my .Net C# Programming skills. I have completed numerous projects on MVC and .Net Cor Больше

$175 USD за 7 дней(-я)
(30 отзывов(-а))
6.3
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Here are my working result in c# [login to view URL] h Больше

$155 USD за 3 дней(-я)
(24 отзывов(-а))
5.3
naryl

Hello. This project can be very clearly broken up in pieces, that's: 1. Reading the XML. 2. Creating the database according to XML schema. 3. Validating fields according to PAD 4. Writing the data. 5. Winforms GUI. I c Больше

$250 USD за 7 дней(-я)
(18 отзывов(-а))
4.9
wulongzhu87

Hi there! My name is Longzhu and I’m a professional developer with 7+ years of experience. I'm honesty, communicable, responsible and passionate about web programming holding my hand on a pulse of a new technologies e Больше

$200 USD за 5 дней(-я)
(5 отзывов(-а))
5.0
trustworthyDev

Hi, I have already worked to convert XML data into the database and c# is my favorite language. I will implement your features according to PAD specification and create it using Win Form Solution. Feel free to contact Больше

$800 USD за 7 дней(-я)
(4 отзывов(-а))
4.9
angnut

Hello, I am very much interested in working with you on this project. I have a lot of experience on import data using C#, SQL and XML (or other format). Please contact me to start. Angelo

$190 USD за 4 дней(-я)
(9 отзывов(-а))
4.6
xinglong717

I have many experiences in java, SQL, data process. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$250 USD за 7 дней(-я)
(18 отзывов(-а))
4.7
maryumakhter5

Greetings I am an experienced ASP.NET developer with six years behind the keyboard. I have been on the lookout for new opportunities and was fortunate enough to come across your current listing on the Live Career webs Больше

$140 USD за 7 дней(-я)
(7 отзывов(-а))
4.0
TakaAlex

Hi there! Much interested in your project. I can do it in a 5 hours hire me, Thanks --------------------------------------------------------------------

$140 USD за 1 день
(6 отзывов(-а))
4.0
TalAkerele

HI.dear. Nice to meet you. Happy to bid your project. I am very interested in your project. I read your requirements carefully.I see what you mean. I have so many experiences with xml,.net,C#,vb.net,sql, I'd like to wo Больше

$100 USD за 1 день
(6 отзывов(-а))
3.4
bluestar1027

Hello. How are you? I have read your requirements carefully. Your post for the project stood out to me because it is extremely similar to the work I’ve provided for many of my other clients. The biggest mistake I’ve s Больше

$140 USD за 7 дней(-я)
(7 отзывов(-а))
3.6
xiaowu81

Hi I am c sharp expert. I have good experience with xml. Xml is used for input or output and is saved into db in my progrmas(ExecuteXmlReader()). I finished many programs(desktop LED, android, ios) such as UWP, Xamarin Больше

$250 USD за 7 дней(-я)
(3 отзывов(-а))
3.4
HighDevleoper

Hello, We are IT-Engineers and Business Analysts, creating complete web and mobile solutions, for already more than 10 years, supporting our products with custom digital marketing strategies and instruments. We Exper Больше

$50 USD за 1 день
(3 отзывов(-а))
3.1
logos106

Hello, Sir. I am so interested in this work and would be happy if I can do it for you. I have Visual Studio 2017 Community Edition installed now and have been using it for developing C# applications. Also I have good Больше

$120 USD за 7 дней(-я)
(2 отзывов(-а))
2.3
susanna2018

⭐⭐⭐ Hi, Dear client. ⭐⭐⭐ I'm very interested your project. I read your description carefully. I'm very talented C# developer. if you assign to me this project, you can get a cool result. please contact me. thanks. Больше

$140 USD за 7 дней(-я)
(2 отзывов(-а))
2.1
Friends4it

We already have built large scale applications, CRMs, ERPs and huge systems can be found at our website. Like [login to view URL] [login to view URL] [login to view URL] [login to view URL] https: Больше

$250 USD за 7 дней(-я)
(4 отзывов(-а))
5.4
realstar84

Hello! I recently have developed Freight Booking System with C#, .NET, MSSQL Server, ASP.NET MVC. You can check our website here: https://www.mainfreight.com. I have 5+ years of experience in .NET Software Development. Больше

$150 USD за 1 день
(1 отзыв)
0.7
farmanali0124

Hi there, I have checked the details. I have rich experience with .NET, C# Programming, SQL, XML. Please initiate the chat so we can discuss this job in detail. I am new to freelancer.com but I assure you that I can d Больше

$155 USD за 6 дней(-я)
(0 отзывов(-а))
0.0
dreamgirl1992010

Hello, Sir I have just read your requirements and I can help you with my skills and experiences. I am an expert in C# programming with rich experience. I am sure that I will make the perfect product you are satisfied w Больше

$70 USD за 7 дней(-я)
(0 отзывов(-а))
0.0