Is there some sort of MySQL version of Northwind around that we can test this 
with?

Could you please give a a sample SqLite schema that we can use as a "validator" 
for
the tests ?

We have a new SQLite provider that will be shipping with CodeSmith. If you 
would like
this send me an email.

[deleted comment]

I personally think that THIS is THE missing nt piece to be added in the 
official branch. 
I always worked with sql2000 and recently tried 2005/2008 ... they are too big 
and
slow. Too many megabytes, too much missing features in free editions, and too 
much
expansive the commercial ones. I tried mysql and its clean, fast and feature 
rich,
since 5.0 version on. If only i could use nettiers against mysql, well ... REAL
performance and time saving, EVEN db side. All this words to say, THANK YOU .. 
and
hoping to see this in the official branch as soon as possible. :)

Issue 194 has been merged into this issue.

Hello,

Updated the patch to revision 826. I removed some of the code in the generic 
provider.

Thanks
-Blake Niemyjski

I have applied all the patched and compiled the template when i run this it 
raised
the following exception


System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
   at _CodeSmith.NetTiers_cst.LoadTemplates() in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\TemplateLib\CreateTemplates.cs:li
ne 244
   at _CodeSmith.NetTiers_cst.Go() in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\NetTiers.cst:line 1034
   at _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control control) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\NetTiers.cst:line 4811
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at ej.s()

Hello,

I just upgraded the patch, I would take a look at line 244 of the following 
template: 
TemplateLib\CreateTemplates.cs. And make sure its pointing to the correct file.

Thanks
-Blake Niemyjski

thanks for the reply....
here is another exception if we use the views

System.OverflowException: Value was either too large or too small for an Int32.
   at System.Convert.ToInt32(UInt64 value)
   at System.UInt64.System.IConvertible.ToInt32(IFormatProvider provider)
   at MySql.Data.MySqlClient.MySqlDataReader.GetInt32(Int32 i)
   at SchemaExplorer.MySQLSchemaProvider.MySQLSchemaProvider.GetViewColumns(String
connectionString, ViewSchema view)
   at SchemaExplorer.ViewSchema.get_Columns()
   at _CodeSmith.NetTiers_cst.MappingInstance.__RenderMethod1(TextWriter writer,
Control control) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\SchemaMapping\NetTiersMapInstance
.Internal.cst:line
38
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at _CodeSmith.NetTiers_cst.MappingInstance.Render(TextWriter writer) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\SchemaMapping\NetTiersMapInstance
.Internal.cst:line
51
   at _CodeSmith.NetTiers_cst.Go() in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\NetTiers.cst:line 1015
   at _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control control) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\NetTiers.cst:line 4811
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at ej.s()

here is an other exception plz let me know in which file i should diggout


System.InvalidOperationException: There is an error in XML document (284, 1). 
--->
System.Xml.XmlException: Unexpected end of file has occurred. The following 
elements
are not closed: View, NetTiersMap. Line 284, position 1.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String arg)
   at System.Xml.XmlTextReaderImpl.ThrowUnclosedElements()
   at System.Xml.XmlTextReaderImpl.ParseElementContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlTextReader.Read()
   at System.Xml.XmlReader.ReadStartElement()
   at
Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderNetTiersMap.
Read6_ViewMetaData(Boolean
isNullable, Boolean checkType)
   at
Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderNetTiersMap.
Read7_NetTiersMap(Boolean
isNullable, Boolean checkType)
   at
Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderNetTiersMap.
Read8_NetTiersMap()
   --- End of inner exception stack trace ---
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String
encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(TextReader textReader)
   at MoM.Templates.CommonSqlCode.LoadMappingFile(String path) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\TemplateLib\CommonSqlCode.cs:line
 1810
   at MoM.Templates.CommonSqlCode.GetMapping(String path) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\TemplateLib\CommonSqlCode.cs:line
 1817
   at _CodeSmith.NetTiers_cst.Go() in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\NetTiers.cst:line 1009
   at _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control control) in
c:\Users\umarkashmiri\Downloads\nettiers-2.3.0\NetTiers.cst:line 4811
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at ej.s()

Hello,

I uploaded a new patch, I can generate north wind with views against it but 
there is 
a problem loading the xslt to create the procedures. If you would take a look 
into 
this I think we would have MySQL Support. As for those other two errors. If you 
sent 
me your MySQL Schema I could take a look into the error your seeing.

Thanks
-Blake Niemyjski

Thanks Blake for your reply.
I have attached my database schema please look into it... one thing more, Can 
you
tell me the easiest way to apply schema patch. I 'll be very thankful if you 
send me
the whole nettier template for mysql to my email address.i.e 
umarkashmiri@gmail.com

Thanks you very much

Hello,

Please follow this guide for applying the patch via svn 
(http://tortoisesvn.net/docs/release/TortoiseSVN_en/tsvn-dug-patch.html). I 
need a 
MySQL Schema backup. The above file won't work.

Thanks
-Blake Niemyjski

This mysql schema file is taken by using sqlyog. ok i'll sent you another..
Please have a look at keywords like name in sqlserver is written as [name]
but in mysql it doesnt work. we need to use table.name etc.
I see another bug in CommonSqlCode.cs file

public ColumnSchemaComparer(string sortBy, SchemaExplorer.TableSchema table,
NetTiers.NetTiersMap currentNettiersMap) {
    if (currentNettiersMap == null)
    {
      throw new Exception("There is no mapping file currently available");
          _sortBy = sortBy;
      _table = table;
     _currentNettiersMap = currentNettiersMap;
    }
}
Thanks
Umar Kashmiri

Hello,

I'd apply the patch and then continue to fix bugs. You will have to do some 
work in 
order for it to work. Once this is complete or you have any questions please 
also 
post an updated patch file.

Thanks
-Blake Niemyjski

Hi Blake,
I have attached the schema file.Can you please check it?
Thanks,
Umar Kashmiri

I debug the whole Template code and find that Columns of the views are not 
properly
loaded.
templateSourceViews.InnerArray[0].Columns' threw an exception of type
'System.OverflowException
I searched a lot in template where this array is populated but could not find 
it.Can
you please gimme a hint.
Thanks

Hi, 
I have applied the lastest patch and when I try and run it I am getting the 
following in the debug window:
*Message:Validating parameters.
*Message:Loading templates.
*Message:Creating folders and copying dependencies.
    *File Created: ListBase.cs
    *File Created: TList.cs
    *File Created: VList.cs
    *File Created: TestUtility.cs
    *File Created: IEntity.cs
    *File Created: IEntityId.cs
    *File Created: IEntityKey.cs
    *File Created: EntityFactory.cs
    *File Created: EntityFactoryBase.cs
    *File Created: IEntityFactory.cs
    *File Created: IEntityCacheItem.cs
    *File Created: EntityCache.cs
    *File Created: EntityLocator.cs
    *File Created: EntityManager.cs
    *File Created: BrokenRule.cs
    *File Created: BrokenRulesList.cs
    *File Created: CommonRules.cs
    *File Created: ValidationRuleArgs.cs
    *File Created: ValidationRuleHandler.cs
    *File Created: ValidationRuleInfo.cs
    *File Created: ValidationRules.cs
    *File Created: EntityBaseCore.generated.cs
    *File Created: EntityKeyBaseCore.generated.cs
    *File Created: EntityFilter.cs
    *File Created: EntityPropertyComparer.cs
    *File Created: GenericTypeConverter.cs

At this point I am getting a pop-up error about "This provider is not 
supported". 

Can you point me in the right direction on this problem.

(The mysql database is a work in progress and only has some of the table (no 
views 
or stored procedure yet))

Thank you in advance for any help.

Hello,

I'll take a look into your schema.

@drbigbyte What SchemaProvider are you using? What version of CodeSmith are you 
using?

Thanks
-Blake Niemyjski

Hi Blake,

I am using the MySQLSchemaProvider. 
The CodeSmith version is Professional 5.1.6 Revision 9466

Thanks!

Hi,
yes sure we'll help you.Can you please give us a little hint so that we may also
debug the template and provide the patches if need.Currently i attach the Visual
studio debugger to code smith to see the errors and corresponding variable 
values.Is
there any other way to debug?


Thanks

Umar Kashmiri

Hello,

@drbigbyte, @Dave, @unmarkashmiri Can you please upgrade to the following 
nightly 
build(http://codesmithtools.com/download/builds/codesmithprofessional-52-build.m
si). Please give it 30 minutes 
from the time I send this to build the latest MySQL fix. I have fixed some 
issues with the provider including 
the Overflow Exception.

I do have one bad piece of information. The MySQLSchemaProvider still doesn't 
support GetCommandParameters() 
or GetCommandResultSchemas() with this said there is no way to support 
generating existing stored procedures. 
You must change the CustomProcedureStartsWith property to something that will 
not match any of your stored 
procedures like entering 12323423_{0}. The reason for this is MySQL won't be 
implementing 
Information_Schema.Parameters until MySQL 6.0, which is currently in Alpha. 
Here is the bug very old bug 
report with the information (http://bugs.mysql.com/bug.php?id=20032).

Also, I have updated the providers namespace it was previously 
SchemaExplorer.MySQLSchemaProvider.MySQLSchemaProvider. Please copy your 
connection strings before upgrade and 
delete your saved connections and readd them after installing the new build. I 
created a task for our upgrade 
tool to automatically do this but as of yet it has not been completed.

Thanks
-Blake Niemyjski

Hello,

@unmarkashmiri The best way to debug the templates is to set the Debug 
attribute to 
true and then find the piece of code you need to debug and add a <% 
System.Diagnostics.Debugger.Break(); %> It is a slight pane but the only way to 
debug. Also follow our debugging tips and tricks 
(http://community.codesmithtools.com/blogs/blake/archive/2009/06/03/tips-amp-tri
cks-
debugging-codesmith-on-microsoft-windows-7.aspx).

Thanks
-Blake Niemyjski

Dear Blake,
I debug the whole code and got to know that codesmith 5.2 is still using mysql
connector version 5.0.7 but most of the bugs are fixed in 5.1.7.
Due to which the schema Explorer is unable to explore the view columns and Final
generated don't work well.Can you please let tell me when you people are 
releasing it
for mysql.I really need it urgently.

Thanks,
Umar Kashmiri

Hello,

CodeSmith should be using what ever MySQL assembly is located on your computer. 
Do you 
have the connector url to download so I can make 100% sure all of our internal 
references are up-to-date.

Thanks
-Blake Niemyjski

Hi,

Here is the link for the latest dotnet connector i.e 6.2.2
http://dev.mysql.com/downloads/connector/net/

Thanks
UmarKashmiri

Hello,

I did some checking and we are not referencing any specific version of the 
MySQL .NET 
connector. It is safe to install the latest version. What did you find that 
made you 
think otherwise? Could you please elaborate.

Thanks
-Blake Niemyjski

Hi Blake,
Please find the attachment and see the comparison. If i try to open the view in
sqlYog or in any other GUI of MySQL then it opens correctly,but when i try to 
open
the views through schemaExplorer of CodeSmith 5.2 then it raised the
exception.SchemaExplorer for all kind of database has dll and there is an error 
in
it,may be in this function.
(SchemaExplorer.ViewSchema.get_Column)

See snapshot for more information
Thanks,
UmarKashmiri

Hello,

I fixed this bug the other day as stated in Comment #29. Please upgrade to the 
following nightly 
build(http://codesmithtools.com/download/builds/codesmithprofessional-52-build.m
si) 
to resolve this issue.

Thanks
-Blake Niemyjski

Oh Thank you very much Blake...Finally i generated the code...there are couple 
of
major issues in mysql.data.mysqlclient.procedures file.and trying to figuring 
out the
solutions of more problem.e.g the major problem in find method. @@RowCount is 
used
which is sqlserver syntax will be replaced by FOUND_ROWS() etc... once the 
procedure
file is finalized i'll post the patch.
Thanks again.
Umar Kashmiri

Hi all,

Multi query feature is turned off by mysql and multi-query is used in 
mysql.procedure
file... does anybody know how to handle this problem in procedures. Most of the
methods use multi-query like getpagged etc. I have posted the problem on mysql
forums.Check the link below.
http://forums.mysql.com/read.php?10,301849

Hello,

I wish I could help you on this one. I'm not a MySQL guru by any means :\. It 
will be interesting to see what they respond with.

Thanks
-Blake Niemyjski

Hello,

Does anyone have an up-to-date patch for this?

Thanks
-Blake Niemyjski

Hi
I R&D over it alot. But there are some queries that cannot be converted into 
mysql. and 
mysql stopped supporting multi query. Any how please find the attachment for 
the latest 
patch

Hello,

Thanks, what do you mean by mysql stopped supporting muti query?

Thanks
-Blake Niemyjski

Hello,

Here is the patch for revision 833.

Thanks
-Blake Niemyjski

In most of the methods like getpaged we usually use @ROWCOUNT query along with 
the
select query.and it returns us 2 result sets.As mysql is not supporting multi 
query
so it returns only one result set.
In some IDE's like sql yog it returns on the total  count while in phpMyAdmin it
shows select records. When i posted a problem on mysql forums they people said 
that
multi query was a security hole and we disabled this feature.

Hello,

Couldn't we make RowCount and output parameter or make second call to the db 
for count?

Thanks
-Blake Niemyjski

yes it can be possible......  by sending 2 queries one be one.Do let me know 
about
your opinion.

but I tested
MySQL is support multi query
In the methods like getpaged, it return 2 result

by the way MySql-netTiers-833.patch has some bugs..

Hello,

What bugs does it have? If you could fix them and update this post with a new 
patch 
that would be great!

Thanks
-Blake Niemyjski

Hi Blake,
I have started working on it to fix the bugs and will be back to you soon with 
90% 
working template.Also i m creating a new repository on google code for nettiers 
mysql 
template.

Thanks
Umar Kashmiri

Hello,

That is great news. I wouldn't create a new repository for this as it is 
something no 
one would check and then you would have two different versions out of sync. If 
you 
could add an updated patch that would be great.

Thanks
-Blake Niemyjski

Thanks regretle...@163.com,d...@medicalworkers.com, federico.bessone,jroland 
and all other members of the forum specially Blake for you help and support for 
creating this template.Please visit the link below
http://omarkashmiri.blogspot.com/2010/06/nettiers-mysql-template.html

Thanks,
Umar Kashmiri

Hello,

Great work! Is there anyway you could merge these changes into revision 843. It 
would make it much easier for me to review. I'll commit these changes into core!

Thanks
-Blake Niemyjski

Hi,

Sorry for the delay i'd been very busy..... please find the attachment of mysql 
patch. i updated the nettiers template for MS-SQL and create a patch for 
mysql.Unfortunately i lost the revision 843 changes thats y i had to do so.....
Thanks

Umar Kashmiri

@umarkahmiri how to you open a .patch file?

Hi Geocipher,

Please follow the below link to know how to apply the patch to files.

http://tortoisesvn.net/docs/release/TortoiseSVN_en/tsvn-dug-patch.html

Get the latest nettiers template repository and apply the patch

Thanks,
Umar Kashmiri

Hello,

This has been patched and fixed in revision 857. Please get latest to test 
initial MySQL Support. Please log new MySQL issues in a new thread with 
complete reproduction steps and schema if needed. If someone could log an issue 
with needing to create a new XSLT for writing out the MySQL parameters that 
would be greatly appreciated.

Thanks
-Blake Niemyjski