Migrate Oracle database datatypes to Sql database datatypes in c# .net

See more:

C#2.0

C#

SQL-Server

Hi Good morning ,

Here we need to migrating the qracle databse to sql server.
here we are using c#.net applicaion.

sapmle code for Oracle given below.

public DataSet GetL3CompanyDesc()
		{
			DataSet dsCompanyDetails = new DataSet();
			try
			{
				oracleConnection = new OracleConnection(connectionString);

				OracleParameter[] arrayParameter = new OracleParameter[2];

				arrayParameter[0] = new OracleParameter(IODDALConstants.GetL3CompanyDescRefCur, OracleType.Cursor);
				arrayParameter[0].Direction = ParameterDirection.Output;

				arrayParameter[1] = new OracleParameter(IODDALConstants.GetL3CompanyDescCubeVersion, OracleType.Cursor);
				arrayParameter[1].Direction = ParameterDirection.Output;

				OracleHelper.FillDataset(oracleConnection, CommandType.StoredProcedure, IODDALConstants.GetL3CompanyDesc, dsCompanyDetails, new string[] { IODDALConstants.GetL3CompanyDescTableName }, arrayParameter);
			}
			catch (Exception ex)
			{
				bool rethrow = ExceptionLogEntry.HandleDALException(ex);
				if (rethrow)
				{
					throw;
				}
			}
			finally
			{
				if (oracleConnection != null)
					oracleConnection.Dispose();
			}
			return dsCompanyDetails;
		}

How can i change it to Sql

Anybody can please help me out this issue.

Regards
KishoreD