Question

Develop a C# solution that retrieves a table definition from a SQL Server database and generates the C# source code representing the table as a C# class. The SQL used to obtain the table information is shown below. SELECT C.object_id, C.name as 'column_name', C.column_id, C.system_type_id, T.name as 'system_type_name', C.max_length, C.is_nullable FROM SYS.columns C, SYS.types T WHERE C.system_type_id = T.system_type_id AND C.object_id = (SELECT object_id FROM SYS. TABLES WHERE name = 'STT001_STUDENT') ORDER BY C.column_id; Query Results: object_id column_name column_id system_type_id system_type_name max_length is_nullable 1205579333 Id 1 56 int 4 0 1205579333 GPA 2 108 numeric 5 0 1205579333 MajorCode 3 175 char 5 0 1205579333 FirstName 4 167 varchar 50 0 1205579333 LastName 5 167 varchar 50 0 An example output for this program is shown below. public class Student { public int Id { get; set; } public decimal GPA { get; set; } public string MajorCode { get; set; } public string FirstName { get; set; } public string LastName { get; set; } } Even though the program is not yet complete, there is a buzz around the office about how helpful this feature will be for other databases (e.g., Oracle, SQLite, MySQL, etc.) in addition to SQL Server, so the design should support extending the application to support additional source databases as enhancements in future. Additionally, there is a discussion of supporting other language outputs, including Java, C++, Visual Basic, and Python; however, the initial deployment is only required to support the C# programming language.

          Develop a C# solution that retrieves a table definition from a SQL Server database and
generates the C# source code representing the table as a C# class. The SQL used to obtain the
table information is shown below.
SELECT
C.object_id,
C.name as 'column_name',
C.column_id,
C.system_type_id,
T.name as 'system_type_name',
C.max_length,
C.is_nullable
FROM SYS.columns C, SYS.types T
WHERE C.system_type_id = T.system_type_id AND
C.object_id = (SELECT object_id FROM SYS. TABLES WHERE name = 'STT001_STUDENT')
ORDER BY C.column_id;
Query Results:
object_id column_name column_id system_type_id system_type_name max_length is_nullable
1205579333 Id 1 56 int 4 0
1205579333 GPA 2 108 numeric 5 0
1205579333 MajorCode 3 175 char 5 0
1205579333 FirstName 4 167 varchar 50 0
1205579333 LastName 5 167 varchar 50 0
An example output for this program is shown below.
public class Student
{
public int Id { get; set; }
public decimal GPA { get; set; }
public string MajorCode { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}
Even though the program is not yet complete, there is a buzz around the office about how
helpful this feature will be for other databases (e.g., Oracle, SQLite, MySQL, etc.) in addition to
SQL Server, so the design should support extending the application to support additional source
databases as enhancements in future. Additionally, there is a discussion of supporting other
language outputs, including Java, C++, Visual Basic, and Python; however, the initial
deployment is only required to support the C# programming language.

Develop a C# solution that retrieves a table definition from a SQL Server database and
generates the C# source code representing the table as a C# class. The SQL used to obtain the
table information is shown below.
SELECT
C.objectid,
C.name as 'columnname',
C.columnid,
C.systemtypeid,
T.name as 'systemtypename',
C.maxlength,
C.isnullable
FROM SYS.columns C, SYS.types T
WHERE C.systemtypeid = T.systemtypeid AND
C.objectid = (SELECT objectid FROM SYS. TABLES WHERE name = 'STT001STUDENT')
ORDER BY C.columnid;
Query Results:
objectid columnname columnid systemtypeid systemtypename maxlength isnullable
1205579333 Id 1 56 int 4 0
1205579333 GPA 2 108 numeric 5 0
1205579333 MajorCode 3 175 char 5 0
1205579333 FirstName 4 167 varchar 50 0
1205579333 LastName 5 167 varchar 50 0
An example output for this program is shown below.
public class Student

public int Id get; set;
public decimal GPA get; set;
public string MajorCode get; set;
public string FirstName get; set;
public string LastName get; set;

Even though the program is not yet complete, there is a buzz around the office about how
helpful this feature will be for other databases (e.g., Oracle, SQLite, MySQL, etc.) in addition to
SQL Server, so the design should support extending the application to support additional source
databases as enhancements in future. Additionally, there is a discussion of supporting other
language outputs, including Java, C++, Visual Basic, and Python; however, the initial
deployment is only required to support the C# programming language.

Added by Brenda T.

Question

Please give Ace some feedback