将应用程序从sqlserver更改为oracle [英] changing application from sqlserver to oracle

问题描述

你好，

我和我的两个朋友(我们都是初学者)向客户端开发了一个应用程序.我们使用了sqlserver数据库和linq查询.
现在我们的客户希望使用oracle数据库使用相同的应用程序.我们是否需要重做所有工作(就像我们在第一个sol°中使用linq一样)，并且为了将来使用，使用ado.net，linq，实体框架或其他ORM的更好解决方案是什么?

预先谢谢您:)

Hello,

Me and two of my friends (we are all beginners) developpped an application to a client .We used a sqlserver database and linq queries.
Now our client wants the same application with an oracle database.So i have many questions; do we have to redo all the work(as we used linq in the first sol°), and for future use what is the better solution to use ado.net ,linq, entity framework or other ORM.

Thank you in advance:)

推荐答案

这取决于设计.如果您的应用程序数据访问使用的是某些ORM，并且/或者物理上存在单独的数据访问层(即，单独的项目)，那么您只需要在那部分上进行重做，其余的应用程序可以保持不变.

It depends on the design. if yuor application data access is using some ORM and/or there is a separate Data access layer physically (i.e. separate project) then you just have to rework on that part and rest of the application can remain the same.

类方法中的代码会给您带来很大的麻烦，您无法更改数据库.这就是为什么首选n层体系结构的原因.我可以给您2个实现n层架构的链接(也许您会发现它们很有用.

1. YaBlogEngine-用ASP编写的微型博客引擎. NET/C# [ ^ ]

2. YaMessaging-一种类似于邮件的简单电子邮件应用程序 [ ^ ]

The code in class methods will give you a big trouble in changing the database. That is why the n-tier architecture is preferred. I can give you 2 links which has n-tier architecture implemented (perhaps you may find them useful.

1. YaBlogEngine - A Tiny Blog Engine written in ASP.NET/C#[^]

2. YaMessaging - A simple e-mail like messaging application[^]

这篇关于将应用程序从sqlserver更改为oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！