Adding a Computed Column/Field In View Using Method & SQL Statements.
- Add a new method “Computed” in your view.You can fully utilize SQL case statements, SQL Functions, SQL direct statements as per your requirements.
- Add a new string computed column or field in your view.
- Change the property of computed column and select your method name in “View Method” property.
- Build and Synchronize the project.Your view is now ready to use.
- You SQL View should look like this.Cheers …Piyush Adhikari