Store multiple text lines in a tables column in SQL server

miladel

Member
Joined
Aug 16, 2020
Messages
10
Programming Experience
Beginner
Dear All,
I am working on a UWP app and I am using Dapper to connect to SQL Server2019. User must be able to put a text like this:

1.abc..
2.xyz..
3.mnp..
...

into a nchar column in SQL server and also read this multiple text in the app.

What is the best way to do this job? What are the controls and the coding

thanks
 

Skydiver

Staff member
Joined
Apr 6, 2019
Messages
2,994
Location
Chesapeake, VA
Programming Experience
10+
Is each line meant to be a separate database row, or is all the text meant to stay together as a single block?
 

miladel

Member
Joined
Aug 16, 2020
Messages
10
Programming Experience
Beginner
Is each line meant to be a separate database row, or is all the text meant to stay together as a single block? it means all the text stay together
 

Skydiver

Staff member
Joined
Apr 6, 2019
Messages
2,994
Location
Chesapeake, VA
Programming Experience
10+
So have a single string member in your class that represents that text, and let Dapper do it's thing to save the class.
 
Top Bottom