rbfigueira.net

The best O/R Mapper

2006-08-20T12:05:00Z

Some people have developed tools called ORM (Object Relational Mappers) utilities, which can make it easier to map database tables, views and other relational objects to an OOP class. They can explore the database´s shema and create the wapper custom entity and domain object classes for you.

Some of them work at design time and others work at runtime to perform this mapping function on-the-fly. The problem here is that sometimes they don´t work as well as we´d like them to, and there can be a considerable learning curve to set up these tools to work with some particular database and usage requirements.

Some of them don't have the basic support for joins or for stored procs !!

Some popular tools for .NET are:

NHibernate
EntityBroker
LLBLGen
ORMapper
Base4.Net
ADO.NET Entity Framework / DLINQ (only in Alpha/beta stage)

Note: This is a very simple list and you can add more here.

Some of them are too expensive and others are free! If you use one particularly O/R Mapper build by you and want to share it... dont be afraid ....I love to use it :)

I am trying to find one simple O/R Mapper that have support for joins and for stored procs. The O/R Mapper must work with SQLServer, MySQL and ...

Suppose that I will use your favourite O/R Mapper tool, how you do this :

SqlCommand oCmd = new SqlCommand("My_StoreProcedure");
oCmd.CommandType = CommandType.StoredProcedure;
oConn.Open();
oCmd.Connection = oConn;
oCmd.Parameters.Add("@MyPar", SqlDbType.Int).Value = myPar;
oCmd.ExecuteNonQuery();
oConn.Close();

Note: Is only to see how easy is to use your favourite O/R Mapper ;P You can translate this sample or you can put your sample using stored procedures or simple SQL queries text.

Express your own opinion about these or other O/R Mapper tools and explain how easy is to use it. Talk also about them learning curve.

What I'd like to see here is your opinion base on your own experience. :p

Migrating .Text 0.94 to CS

2005-07-08T11:05:00Z

I am the owner of one community that use and have installed the .Text 0.94
We have more then 90 bloggers… yeap ;p

I want to migrate this system (.Text 0.94) to the new community server (CS).
I don’t want to lose the bloggers and older posts !!!

Can someone point me the right steps I have to do?
Anyone has made his?

Note :
I have also put this question on community server (forums)
http://communityserver.org/forums/490954/ShowPost.aspx

Thanks

PontoNetPT event

2004-10-18T09:06:00Z

The PontoNetPT community was created with the objective to join all the programmers who speak Portuguese, who intend to learn or that already are developing applications with this new platform NET. In this event we talk about the possibility to know some techniques and tools that will be able to help in the process of development and implementation it on them projects, thus optimisation its applications of a fast and robust form.

We have made one big meeting in 15 October and I want to share some photos.

The sessions where about:

- ASP.NET - Techniques to improve performance

- Tools and strategies of development

- Development of Unitary Tests with the Nunit

- Using the CruiseControl.Net and tools associates to mount a process of Continuous Integration.

From left to right:
João Cardoso [MVP], José Almeida [MS], Ricardo Figueira [PontoNetPT], Nuno Costa [MS] e João Miranda [PontoNETPT]

Note: Do you want to see more ? :PPP
http://weblogs.pontonetpt.com/rbfigueira/gallery/384.aspx

Problems with Webhost4life

2004-10-08T08:48:00Z

We have one Portuguese dotnet community (PontoNetPT) that use Community Starter Kit

We are having a big problem and I want to share with you (I know that same of you use that host). :/

We are using Webhost4life host for months but last month they turn off our site two times (now is off):

Support:
"Looks like the database is stopped because you are using 100% cpu usage"

1- They don’t tell us that they will turn off our site. Bad, very BAD!!
2- They only give us that message and no tips or help about the problem.

We are thinking moving to other host because the support is not very good!!!!
Everything is stop because of that. Perhaps they don’t like our traffic !! ;P

Is any problem with Community Starter Kit?
Anyone have a similarly problem?

PontoNetPT (community) event

2004-09-24T15:08:00Z

Is only to say that our community will do a big event in Portugal (yes, we are a Portuguese Community) ;P

Agenda
http://www.microsoft.com/portugal/msdn/eventos/PontoNet/default.aspx

Local of event:

15/10/2004, 9:00-18:00 - Lisboa (Porto Salvo)

Auditório da Microsoft

Edifício Qualidade, C1 - C2

Av. Prof. Doutor Aníbal Cavaco Silva

Tagus Park

2744-010 Porto Salvo

PORTUGAL

I hope to see some friends of PontoNetPT community ! ;)

Note: On 16/10/2004 I will post some pictures in the gallery ;P

PontoNetPT (Weblogs)

2003-12-19T16:27:00Z

I am the owner of one .NET Portuguese community (PontoNetPT).

We have installed the .Text ;)

Now, the people that talk Portuguese can have them own weblog in Portuguese ;)

Check this :

PontoNetPT – Portuguese .Net Group

2003-12-05T14:27:00Z

This post is only to people that understand Portuguese ;)

Yeap! Is true. There is one .Net group that talk about .net platform since 2 de November 2001 only in Portuguese language. We are more or less 300 programmers…

Here is the link http://www.pontonetpt.com

This site is hosted on a free server (have many limitations) and is only to give support to our group. Perhaps someone here can dispense some space to host for free this site ;) Note that we don’t have any profits in mind!

If you don’t speak Portuguese, please don’t join. We only talk Portuguese in that mailing list :)

Free ebook (Programming the .NET Compact Framework)

2003-11-13T10:17:00Z

"Paul and Dave are simultaneously writing two Compact Framework books: one with all C# samples, the other with all VB samples. (The samples are going to be made available for download to registered users.) Prior to the publication, all chapters from both books will be made available on this website for public review and comment."

Check his link:

http://www.paulyao.com/cfbook/index.asp

--------------------------------------------------

PART 1: FOUNDATIONS

1 Compact Framework Architecture

2 What is a Compact Framework Program?

3 Fundamental .NET Data Types

4 Platform Invoke

PART 2: USER-INTERFACE PROGRAMMING

5 Creating Forms

6 Mouse and Keyboard Input

7 Inside Controls

8 Data Binding

9 Inside More Controls

10 Custom Controls

PART 3: MANAGING DEVICE DATA

11 Storage

12 ADO.NET Programming

13 Synchronizing Mobile Data

14 Remote API (RAPI )

PART 4: CREATING GRAPHICAL OUTPUT

15 Compact Framework Graphics

16 Text and Fonts

17 Printing

A Appendix A: Hungarian Naming for .NET

--------------------------------------------------

Thanks, Paul Yao and David Durant for sharing that ;)

Note: Register online at http://www.paulyao.com/ReaderFeedback, to get access to complete chapters

Differences Between VB.NET / C#

2003-11-12T15:29:00Z

"....Because of the past differences between Microsoft® Visual Basic, Microsoft® Visual CT, and Microsoft® Visual C++, many developers have the impression that Microsoft® Visual C# .NET is a more powerful language than Microsoft® Visual Basic .NET. Some developers assume that many things that are possible in Visual C# .NET are impossible in Visual Basic .NET, just as many things that are possible in Microsoft® Visual CT 6.0 and earlier or Microsoft® Visual C++T 6.0 and earlier are impossible in Microsoft® Visual BasicT 6.0 and earlier. This assumption is incorrect. Although differences exist between Visual Basic .NET and Visual C# .NET, they are both first-class programming languages that are based on the Microsoft® .NET Framework, and they are equally powerful..."

Check this:

Differences Between Microsoft Visual Basic .NET and Microsoft Visual C# .NET
http://support.microsoft.com/?kbid=308470

Don’t forget to do the download ;)

DataBinder (Pros and Cons)

2003-10-19T12:54:00Z

DataBinder.Eval method saves you from writing complex expressions ;)

BUT, using this method does impose a performance penalty on your code, because all the work it does is late-bound. Ok, if we want the fastest possible code, you can replace calls to DataBinder.Eval with explicit casts.

For example:

<%# DataBinder.Eval(Container.DataItem, “myField”,“{0:c}”) %>

An equivalent expression using casts would be this:

<%# String.Format(“{0:c}”,(CType(Container.DataItem,DataRowView)(“myField”))) %>

Good ;)

VB.NET vs C# (best choice)

2003-10-15T09:21:00Z

I was reading this article and .... :
http://www.aspnetpro.com/opinion/2003/09/asp200309en_o/asp200309en_o.asp

"Whether it's just or not, C# developers make more money, get work more easily, and enjoy more prestige than VB developers."

"ASPSOFT president and asp.netPRO columnist Jonathan Goodyear describes how, at his client's insistence, he converted a VB .NET code base to C#, then says, "The overwhelming majority of my clients ... are resolute in their insistence on our use of C# while building their software."

Do you agree with this ?!!

My simple conclusion:
It's crucial to learn C# ;P

Note: I prefer to do my stuff on vb.net but i know both languages (vb.net and c#) ;)

MSDN Event (Lisbon: 08 October)

2003-10-13T09:59:00Z

I was on the MSDN event (Lisbon: 08 October) – Portugal! Yes, that little country ;)

They talk about programming with ADO.NET (good practices) ;)

On “Errors on Stored Procedures” subject:
“ Informative messages (severity <=10) can be capture by ADO.NET” by Vasco Nunes

Example:
“Conn” is your connection
We can build one event handler on infoMessage (connection), like this:

AddHandler conn.infoMessage, New SqlClient.SqlinfoMessageEventHandler(Addressof MessageEventHandler)

Sub MessageEventHandler(ByVal sender As Object, ByVal e As SqlClient.SqlinfoMessageEventArgs)

‘do whatever

End Sub

Great ;)

Pocket PC aggregator (MyMobileNews)

2003-09-10T09:08:00Z

I have started building one Pocket Pc aggregator with .NET Compact Framework and here is one screenshot:

Note: In this stage, i am only doing some tests. The app still have some bugs and its not complete.

Like I have said it will be an RSS/RDF news aggregator that runs on the Pocket PC 2002/3 PDA's. You can read news, blog entries, or any other type of syndicated data, sync it wirelessly or read it offline.

Please wait, very soon I will update the gotdotnet workspace ;)

The releases will be post on GotDotNet Workspace:
http://www.gotdotnet.com/community/workspaces/workspace.aspx?id=f1470873-2d53-4edc-9e02-38d5dee1126b

RE: PocketPc Emulator + Connecting to LocalHost (Solution)

2003-09-10T08:41:00Z

On my pocket pc emulator nothing work.... what a hell !!

(...)

Other weird think is that i have made "ipconfig" and get the network IP address. The IP address did work on (Pocket IE or on Internet Explorer browser).

(...)

Anyone knows what is wrong???
What can i do? Any idea?

Note: See my post on (PocketPc Emulator + Connecting to LocalHost (big problem)) for more detail about this problem.

UPDATE:

Now it works. I have the solution that works on my laptop.
Here are the steps I have done:

[Pocket Emulator]
On network adapters->DC21X4 Ethernet Adapter :
-server assigned address is checked;
-Name Servers - all empty

On Connections I have set this configuration:
-InternetSettings
-Work Setting
-The internet

[LoopBack - Computer]
- Install microsoft loopback adapter and on the properties of the connection created assign IP (example: 10.10.10.10), does not mater witch IP you choose,
and put on Subnet Mask : 255.255.0.0

[Pocket Emulator]
On the IE of Emulator try reaching a web page of your computer, this should work. Do not use your machine name, use the Ip that you have define on the microsoft loopback (ex:10.10.10.10).

PocketPc Emulator + Connecting to LocalHost (big problem)

2003-08-29T09:02:00Z

Ok, this is not the right place to put his but perhaps anyone can help me… I am around this to long days…

I am developing one application (Pocket PC), using my laptop, and i am using the (Pocket Pc Emulator) to do the tests.

I have to use/read one xml file that are on my own machine server (localhost).
That file will be on Internet BUT i want to simulate using my local server (localhost), avoiding connecting to web.

How can i configure the emulator to connect to my server (localhost) ?

I have read this article (Using the Emulator in Smart Device Projects):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/html/grfusingemulatorinsmartdeviceprojects.asp

I have made all steps but did not work... perhaps i am doing something wrong...

I am running the emulator on the same machine (my Laptop - acer aspire) with vs.net 2003 and perhaps my configuration (Connections) is wrong.

The problem is that i can’t view my webpages that are stored on my machine server (localhost). Like I said I have to use some files stored on my machine server (localhost) on one application that i am doing with compact Framework. That files will be on Internet BUT i want to simulate using my local server (localhost), avoiding connecting to web.

My Laptop settings:
Pc name: laptop
Connect Internet: Dial-up Connections (phone line)

I have made this:
++++++++++++++++++

To configure Pocket PC 2002 or Pocket PC 2000 with no proxy server

Click Start on the emulator, click Settings, click the Connections tab, and then click Network Adapters.
Under Adapters installed, click DC21X4 Ethernet Driver, and then click Properties.
Click Use specific IP address, and then enter 192.168.0.2 in the IP address box, and 255.255.255.0 in Subnet mask box.

To install the Microsoft Loopback Adapter in Microsoft Windows 2000

In Windows Control Panel, double-click Add/Remove Hardware, and then click Next.
Click Add/Troubleshoot a device, and then click Next.
In the Devices list, click Add a new device, and then click Next.
Select No, I want to select the hardware from a list, and then click Next.
In the Hardware types list, click Network adapters, and then click Next.
In the Manufacturers list, click Microsoft.
In the Network Adapter list, click Microsoft Loopback Adapter, and then click Next.
Click Next, and then click Finish.
++++++++++++++++++

I have tried without the Loopback Adapter because my Laptop have a Network adapters (Realtek RTL8139(A)-based PCI Fast Ethernet Adapter) BUT did not work !! :(

I have tried this on the emulator (Pocket IE):

http://laptop/mypage.aspx

The page you are looking for cannot be found

http://127.0.0.1/mypage.aspx

Trouble connecting
Unable to connect with current settings. To change your connection settings, tab settings.
[ok] [settings]

I have tried many ways and ... not work!!

After some hours…

I tried to view, with the emulator, some Internet pages, and i recived this error message:

Trouble connecting
Unable to connect with current settings. To change your connection settings, tab settings.
[ok] [settings]

Somethink is wrong!! I went to my PDA (Toshiba e330) and tried to connect to Internet and ... this work fine. I went to connections of my PDA and see that he has using one proxy ?!?! I haven’t put anything there? The proxy is "pbtproxy01" ???!!

Note: My browser (Internet Explorer) doesn’t have any proxy on there!!!

Ok, lets change the Emulator settings...

I have put that proxy on the connection settings and ... i can see Internet pages from Pocket Pc Emulator ;)
Great... now lets try this links (Pocket IE):

*** connecting to internet (on-line) ****

http://laptop/mypage.aspx

error:
Unknown host
Description: Unable to locate the server named "laptop" --- the server
does not have a DSN entry. Perhaps there is a misspelling in the server name,
or the server no longer exists.
Double-check the name an try again.

http://localhost/mypage.aspx

error:
The page you are looking for cannot be found

http://127.0.0.1/mypage.aspx

error:
Internal error - server connection terminated
Description: Internal error - server connection terminated

******************************************

*** NOT connecting to internet (off-line) ****

http://laptop/mypage.aspx

error:
The page you are looking for cannot be found

http://127.0.0.1/mypage.aspx
or
http://localhost/mypage.aspx

error:
The page you are looking for cannot be found

******************************************

Note: I have Test that pages connected to the normal Internet Explorer and then all work fine.

When i am connection to Internet i received some different error that point to some solutions...
When i NOT connected to Internet i received only the message that "The page you are looking for cannot be found". Note that I want to work off-line!

Why i did not received the same messages????

Using my IP did not work, also :(

Here is my settings:

+++++++++++++++++

[ ping laptop ]

Pinging laptop [169.254.25.129] with 32 bytes of data:
Reply from 169.254.25.129: bytes=32 time<10ms TTL=128
Reply from 169.254.25.129: bytes=32 time<10ms TTL=128
Reply from 169.254.25.129: bytes=32 time<10ms TTL=128
Reply from 169.254.25.129: bytes=32 time<10ms TTL=128

Ping statistics for 169.254.25.129:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),

Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

[ ipconfig ]

Windows 2000 IP Configuration

Ethernet adapter Local Area Connection 2:

Connection-specific DNS Suffix . :
Autoconfiguration IP Address. . . : 169.254.25.129
Subnet Mask . . . . . . . . . . . : 255.255.0.0
Default Gateway . . . . . . . . . :

Ethernet adapter Local Area Connection:

Media State . . . . . . . . . . . : Cable Disconnected

[ Computer settings - Network ]

Full computer name: laptop.
workgroup: WORKGROUP

+++++++++++++++++++

When i do this on my Internet explorer browser:

http://laptop/mypage.aspx (laptop is my computer name)

It work fine !

http://169.254.25.129/mypage.aspx (this ip is the "ping" of my computer name).
Don’t work like "laptop"...it will force to connect to Internet ... if i do "connect" it will connect to Internet.

On my pocket pc emulator nothing work.... what a hell !!

The first weird think is that i don’t use any proxy to connect to Internet and on my PDA (Toshiba e330) i went to connections and see that he has using one proxy "pbtproxy01" ???!! If i remove that from my device i will not connect to Internet.
I only can connect to internet using the emulator if i put that proxy... but i cant connect to my local machine server ....

Other weird think is that i have made "ipconfig" and get the network IP address. The IP address did work on (Pocket IE or on Internet Explorer browser).

I have a bad connection (phone line) and it is not practical ($$$$) to do all tests connection to Internet!!

Anyone knows what is wrong???

What can i do? Any idea?