如何使用SubSonic将数据库从SQL Server更改为Oracle？

I write code with SubSonic 2.1.1 and used MSSQL. The project must be run with Oracle now. I changed web.config, and it does not work. Can someone give me a sample which changes database only - changes web.config with subsonic and the rest doesn't change?

我用SubSonic 2.1.1编写代码并使用MSSQL。该项目现在必须与Oracle一起运行。我改变了web.config,但它不起作用。有人可以给我一个只改变数据库的样本 - 用亚音速改变web.config,其余的不改变吗?

Table name in MSSQL is "Name" but in Oracle is "NAME". Can subsonic generate "Name" code for oracle?

MSSQL中的表名是“Name”,但在Oracle中是“NAME”。 subonic可以为oracle生成“Name”代码吗?

1 个解决方案

#1

Based on this question your connections string will need to look like the following (obviously replace xxxxx with your database values):

根据这个问题,您的连接字符串将需要如下所示(显然将xxxxx替换为您的数据库值):

<connectionStrings> 
  <add name="oracle" connectionString="Data Source=xxxxxxxx;Persist Security Info=True;User ID=xxxxx;Password=xxxxx;" providerName="System.Data.OracleClient"/> 
</connectionStrings>

Re. your second question, Oracle is not case sensitive. See this question for more details

回覆。第二个问题,Oracle不区分大小写。有关详细信息,请参阅此问题

#1