how can we map database column from web.config

Question

0.00/5 (No votes)

See more:

Hi,
I am going to use Product Feed from different sites. And I have to save all the product information to out database table.
All the different sites provide different source like Excel or XML file. I have to read that Excel and XML file and save data to our database table.
But all the resources having different column and I have to Map these column according to our database table's column.
Can we map all column in web.config file.
If yes then please help me. How can I map database table's columns in web.config file of asp.net 3.5

Posted 9-Jul-14 1:36am

Binod Kumar Mahto

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shameel · Accepted Answer · 2014-07-09T01:47:00

Here's how I would do it:

1. Create an XML mapping file for each provider
2. Write a Mapper class for each provider that will parse the appropriate XML file and return a common representation of the mapping.
3. Write a Factory class that will instantiate the correct Mapper based on the provider.
4. All these mappers should inherit from an abstract base class that will have the common functionality.
5. Write a class that will take in a Mapper and do the database stuff from the mapper.