 |
|
| .NET DotNet Forum Index » General Discussion » How do I begin thinking on converting MS Access ap to... |
|
Page 1 of 1 |
|
| Author |
Message |
| rg... |
 Posted: Wed Nov 04, 2009 5:33 pm |
|
|
|
Guest
|
Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.
Where do I begin researching/determining how to convert an MS Acess app to
dotnet?
Old VB6 coder here but not sure that is too relevant today.
Thanks. |
|
|
| Back to top |
|
|
|
| Chuck Lucas... |
| Posted: Wed Nov 04, 2009 6:43 pm |
|
|
|
Guest
|
I started here: http://www.microsoft.com/express/download/default.aspx
They also have lots of tutorials and stuff.
"rg" <rg01 at (no spam) NoReplyPlease.NRP> wrote in message
news:eAu9k5ZXKHA.220 at (no spam) TK2MSFTNGP02.phx.gbl...
Quote: Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.
Where do I begin researching/determining how to convert an MS Acess app to
dotnet?
Old VB6 coder here but not sure that is too relevant today.
Thanks.
|
|
|
| Back to top |
|
|
|
| (PeteCresswell)... |
| Posted: Wed Nov 04, 2009 8:07 pm |
|
|
|
Guest
|
Per rg:
Quote: Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.
Where do I begin researching/determining how to convert an MS Acess app to
dotnet?
Old VB6 coder here but not sure that is too relevant today.
I'm in a similar situation except I'm a current MS Access
developer whose current gig seems tb in it's final days/weeks.
Based on a couple of apps I "converted" to VB6 just to see how
the man hours stacked up (a factor of 3 for me), I would say to
think in terms of total rewrite instead of conversion.
My intent is to select a fairly basic application that I have
developed in MS Access and rewrite it using .NET with windows
forms and the freebie SQL Server back end.
--
PeteCresswell |
|
|
| Back to top |
|
|
|
| Patrick A... |
| Posted: Thu Nov 05, 2009 5:46 am |
|
|
|
Guest
|
My 2 cents from my own experience as a new latecomer to VB from
Access:
1. Realize that the data connection and retrieval work is actually
made really easy in the current versions of VB.
2. Learn how to use variables (if you don't know how already) instead
of storing data on invisible form controls.
3. Read up, ask questions and look at samples before you try to
recreate a control, sub or behavior the way you know how in Access.
4. Watch the videos under Learn Visual Basic on the MS website (http://
msdn.microsoft.com/en-us/vbasic/default.aspx) - they're helpful to
learn how to move around quickly and what you don't have to do by
hand.
5. Learn about doing things - like building controls - from code.
Saves lots of time once you get the hang.
6. Use this group as a resource - they're very helpful!!
Patrick. |
|
|
| Back to top |
|
|
|
| John Bundy... |
| Posted: Thu Nov 05, 2009 9:14 am |
|
|
|
Guest
|
It really depends on what you have done, the complexity, and how it is all
tied together. That said, databinding in .NET is confusing at first but
really quite brilliant. I converted a program from Access to .Net about a
year ago and while not difficult, I should have learned more about
databinding first. Since learning much more I was able to recreate almost the
entire project with very little code. It is much faster, simpler, and the
footprint is about 1/3 the original.
Look in to drag and drop binding to get you started. Not to over promote,
but in my "blog" in the sig i have written several tutorials related to
databinding in VS you might find helpful.
--
-John http://www.jmbundy.blogspot.com/
Please rate when your question is answered to help us and others know what
is helpful.
"rg" wrote:
Quote: Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.
Where do I begin researching/determining how to convert an MS Acess app to
dotnet?
Old VB6 coder here but not sure that is too relevant today.
Thanks.
.
|
|
|
| Back to top |
|
|
|
| Mr. Arnold... |
| Posted: Thu Nov 05, 2009 10:08 am |
|
|
|
Guest
|
rg wrote:
Quote: Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.
Where do I begin researching/determining how to convert an MS Acess app to
dotnet?
Old VB6 coder here but not sure that is too relevant today.
UI
MVP or MVC
BLL
WCF
DAL
database model
You should get the book and get the DOFactory software and learn.
http://headfirstlabs.com/books/hfdp/
Dofactory is well worth the price if you're interested in how to
develop n-tiered solutions.
Head First is in the dofactory.
http://www.dofactory.com/Framework/Framework.aspx
I'll give you the rest of my little take on things, which a is needed to
develop solid .NET solutions, particularly Web and SOA solutions.
What is Object-oriented-programming?
(OOP) is a programming paradigm that uses "objects" and their
interactions to design applications and computer programs.
The key concepts of OOP are the following:
Class
Object
Instance
Method
Message passing
Inheritance
Abstraction
Encapsulation
Polymorphism
Decoupling
http://en.wikipedia.org/wiki/Object-oriented_programming
No matter what development platform Java, .Net or others OOP is OOP.
http://math.hws.edu/eck/cs124/downloads/OOP2_from_Univ_KwaZulu-Natal.pdf
http://www.blackwasp.co.uk/ObjectOrientedConcepts.aspx
What are design patterns?
Design patterns are recurring solutions to software design problems you
find again and again in real-world application development. Patterns are
about design and interaction of objects, as well as providing a
communication platform concerning elegant, reusable solutions to
commonly encountered programming challenges.
http://www.developer.com/design/article.php/1502691
http://www.dofactory.com/Patterns/Patterns.aspx
<http://computerprogramming.suite101.com/article.cfm/patterns_and_antipatterns?
http://msdn.microsoft.com/en-us/library/ms954638.aspx
http://www.designpatternsfor.net/Presentations.aspx?tid=3&cid=4
What is Domain Driven Design?
(DDD) is an approach to the design of software, based on the two
premises [1] that complex domain designs should be based on a model, and
that, for most software projects, the primary focus should be on the
domain and domain logic (as opposed to being the particular technology
used to implement the system).
http://en.wikipedia.org/wiki/Domain-driven_design
What is Test Driven Design?
(TDD) is a software development technique that uses short development
iterations based on pre-written test cases that define desired
improvements or new functions. Each iteration produces code necessary to
pass that iteration's tests. Finally, the programmer or team refactors
the code to accommodate changes. A key TDD concept is that preparing
tests before coding facilitates rapid feedback changes. Note that
test-driven development is a software design method, not merely a method
of testing.
http://en.wikipedia.org/wiki/Test-driven_development
http://weblogs.asp.net/rhurlbut/archive/2007/07/16/another-tdd-and-ddd-success-story.aspx
What is Model-View-Controller?
(MVC) is an architectural pattern used in software engineering.
Successful use of the pattern isolates business logic from user
interface considerations, resulting in an application where it is easier
to modify either the visual appearance of the application or the
underlying business rules without affecting the other. In MVC, the model
represents the information (the data) of the application; the view
corresponds to elements of the user interface such as text, checkbox
items, and so forth; and the controller manages the communication of
data and the business rules used to manipulate the data to and from the
model.
http://en.wikipedia.org/wiki/Model-view-controller
http://msdn.microsoft.com/en-us/library/ms978748.aspx
<http://weblogs.asp.net/scottgu/archive/2007/10/14/asp-net-mvc-framework.aspx>
http://cristobal.baray.com/indiana/projects/mvc.html
http://www.devx.com/dotnet/Article/29992/0/page/1
What is Model-View-Presenter?
MVP is a software pattern considered a derivative of the
Model-view-controller.
http://en.wikipedia.org/wiki/Model_View_Presenter
http://msdn.microsoft.com/en-us/magazine/cc188690.aspx
http://mrrask.files.wordpress.com/2008/01/model-view-presenter.pdf
http://www.mvcsharp.org/Reworking_ASPNET_MVC_Store/Default.aspx
<http://www.codeproject.com/KB/aspnet/ModelViewPresenter1.aspx?fid=1531640&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=2822806#Reusing%20the%20presenter%20in%20windows>
<http://codebetter.com/blogs/jeremy.miller/archive/2006/02/01/test-driven-development-with-asp-net-and-the-model-view-presenter-pattern.aspx>
MODEL-VIEW-PRESENTER
http://www.polymorphicpodcast.com/
click 'Shows'
click 'Design Patterns Bootcamp: Model View * Patterns*
view parts 1-5
What is Object Relational Mapping?
(ORM) is a programming technique for converting data between
incompatible type systems in relational databases and object-oriented
programming languages. This creates, in effect, a "virtual object
database," which can be used from within the programming language. There
are both free and commercial packages available that perform
object-relational mapping, although some programmers opt to create their
own ORM tools.
http://en.wikipedia.org/wiki/O-RM
http://www.objectmatter.com/vbsf/docs/maptool/ormapping.html
What is Language Integrated Query?
LINQ is a Microsoft .NET Framework component that adds native data
querying capabilities to .NET languages.
Microsoft LINQ defines a set of query operators that can be used to
query, project and filter data in arrays, enumerable classes, XML,
relational database, and third party data sources. While it allows any
data source to be queried, it requires that the data be encapsulated as
objects. So, if the data source does not natively store data as objects,
the data must be mapped to the object domain. Queries written using the
query operators are executed either by the LINQ query processing engine
or, via an extension mechanism, handed over to LINQ providers which
either implement a separate query processing engine or translate to a
different format to be executed on a separate data store (such as on a
database server as SQL queries). The results of a query are returned as
a collection of in-memory objects that can be enumerated using a
standard iterator function such as C#'s foreach.
Many of the concepts that LINQ has introduced were originally tested in
Microsoft's C? research project. LINQ was released as a part of .NET
Framework 3.5 on November 19, 2007.
http://en.wikipedia.org/wiki/Language_Integrated_Query
What is Linq-to-SQL?
LINQ to SQL, a component of Visual Studio Code Name "Orcas", provides a
run-time infrastructure for managing relational data as objects without
losing the ability to query. It does this by translating
language-integrated queries into SQL for execution by the database, and
then translating the tabular results back into objects you define. Your
application is then free to manipulate the objects while LINQ to SQL
stays in the background tracking your changes automatically.
http://msdn.microsoft.com/en-us/library/bb425822.aspx
What is ADO.NET Entities framework?
ADO.NET Entity Framework is an object-relational mapping (ORM) framework
for the .NET Framework. This framework is Microsoft's first ORM offering
for the .NET Framework. While Microsoft provided objects to manage the
Object-relational impedance mismatch (such as a DataSet).
ADO.NET Entity Framework is included with .NET Framework 3.5 Service
Pack 1 and Visual Studio 2008 Service Pack 1, released on 11 Aug 2008.
It also includes the capability of executing LINQ against ADO.NET Entity
Framework entities
http://en.wikipedia.org/wiki/ADO.NET_Entity_Framework
http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx
http://www.springerlink.com/content/kg3216v2014r00u0/
<http://blogs.msdn.com/adonet/archive/2008/03/27/ado-net-entity-framework-performance-comparison.aspx> |
|
|
| Back to top |
|
|
|
| Mr. Arnold... |
| Posted: Thu Nov 05, 2009 1:41 pm |
|
|
|
Guest
|
rg wrote:
Quote: Currently have an app Front-end MS Access (70 users) backend MS SQL 2005.
Where do I begin researching/determining how to convert an MS Acess app to
dotnet?
Old VB6 coder here but not sure that is too relevant today.
Thanks.
ALinq is like Link-2-SQL but it's Link-2-Access.
http://www.alinq.org/en/default.aspx
Enjoy true portability for your application. ALinq support most of the
commercial databases in use such as Microsoft Access Database, Microsoft
SQL Server, Oracle and MySQL, SQLite, Firebird. |
|
|
| Back to top |
|
|
|
|
|
All times are GMT - 5 Hours
The time now is Thu Nov 26, 2009 11:19 am
|
|