What Is The Reason - String Or Binary Data Would Be Truncated (Validation Failed For One Or More Entities)

> Mainly this error happens in the following situation.
>
1. Length of data to be inserted exceeds the capacity of the field in the table.
> In other words, the field capacity in the table is not enough to hold the inserting data.
> For example, lets consider a table having column field with DataType
varchar(30).
> If we try to insert data of length more than
30, we can get this Error.

> If Entity Framework is used, we will get
Validation Failed For One Or More Entities.
> That means if we insert huge data using Entity Framework, we can get the above error.
> Lets Consider how to resolve this Issue.
How To Resolve - String Or Binary Data Would Be Truncated (Validation Failed For One Or More Entities)
> In order to resolve this Issue, there are two ways.
>
First, Increase the size or length of field in the SQL table.
> In the above case, it was varchar(30). Increase it to varchar(MAX).
>
Second, Trim your data to the length of the table field length.
> If the data is having length 35, then trim the data to length 30.
> By this way we can resolve this issue.
Watch Video of this Content on Video Streaming