Work with computed columns on a view

Example for computed column without SysComputedColumn class.

1. Create a new method on your view

2. Set the method as private static server.

 private static server str GetDayName()
 {   
     ;
     return 'DATENAME(WEEKDAY,T1.TRANSDATE)';
 }

In my example I'm adding a column to get the name of the day from a field of date type. You can do every SQL sentence. T1 represent the alias of the view.

3. Create a string computed column

4. Go to properties of the new computed column created and set the view method