Store multiple text lines in a tables column in SQL server

miladel

Member
Joined
Aug 16, 2020
Messages
14
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
 
Is each line meant to be a separate database row, or is all the text meant to stay together as a single block?
 
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
 
So have a single string member in your class that represents that text, and let Dapper do it's thing to save the class.
 
Back
Top Bottom