建议技术教程和书籍 [英] Suggest technology tutorial and book

问题描述

我是Windows应用程序的C＃.net数据库编程的新手。我尝试编写代码，但我很困惑，因为有许多技术，如实体框架，SQL Server，SQL LocalDB。我无法使用我的旧编程知识。



所以朋友请告诉我我必须使用哪种技术以及任何好的分步教程。



这里我描述了我的应用程序需求：



带有数据库的Windows窗体应用程序

我需要在没有SQL Server的情况下部署应用程序（之前我在此类项目中使用Access）

在我的数据库中有许多表，如Customer Master，Daily Transection，Vehicle Master等。

我喜欢使用过滤器将许多DropDownList框与表数据绑定。

我喜欢根据其他DropDownList来更改DropDownList框数据，这也是与表绑定的。 />


我尝试了什么：



目前我尝试使用C＃.net带有基于服务的数据库的Windows窗体应用程序（LocalDB）。

我能够绑定一些DropDownList，但由于新的DataTable，DataView，RowFilter等而令人困惑。

解决方

您可以在这篇文章中找到一些建议 - Windows窗体教程 [ ^ ]

我对 localDB 的体验也不好，无法让它运转起来。

如果您可以在没有真实数据库的情况下进行管理，并且没有大量数据，则可以使用 XML 来存储数据。

我的数据库目前的选择是 PostgreSQL 与C＃中的 NpgSql 结合使用，它不像<$ c $那样臃肿c> SQL Server ，在不同平台上运行，甚至还有可移植版本。

另一种选择可能是 SQLite ，这是一个教程： Windows 10 Deve lopment SQLite数据库 [ ^ ]

I am very new to C#.net Database Programming for Windows Application. I try to write code but I am totally confused because there are many technologies like Entity Framework, SQL Server, SQL LocalDB. I could not able to use my old programming knowledge.

So friend please suggest me which technology I have to use and any good step by step tutorial of book for that.

Here I describe my Application needs:

Windows Form Application with Database
I need to deploy application without SQL Server (earlier I used Access for this type of project)
In my database there are many tables like Customer Master, Daily Transection, Vehicle Master, etc.
I like to bind many DropDownList box with table data with filter.
I like to change DropDownList box data according to other DropDownList which is also bind with table.

What I have tried:

At present I tried with C#.net Windows Form Application with Service-Based Database (LocalDB).
I can able to bind some DropDownList but it is so confusing because of new DataTable, DataView, RowFilter etc.

解决方案

You can find some suggestions on this post - tutorials for Windows Forms[^]

I had a bad experience with localDB too, couldn't get it working.
If you can manage without a real database, and don't have lot's of data, you could use XML to store your data.
My database of choice at the moment is PostgreSQL in combination with NpgSql in C#, it is not as bloated as SQL Server, runs on different platforms, and there is even a portable version.
An alternative might be SQLite, here is a tutorial: Windows 10 Development SQLite Database[^]

这篇关于建议技术教程和书籍的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！